MyBB Community Forums

Even easier then XD

My forum uses 1.6 So, if you could give that script to me with some instructions (noob in the house! ) I'd be grateful.

Everyday I go and look at my forum wondering if it survived.

Well, its not the simplest script in the world, but I can PM you instrucitons if you like (when i find it on the depths of my PC )

Okay, thanks.

(2010-06-24, 08:09 PM)Tommyk Wrote: [ -> ]Well, its not the simplest script in the world, but I can PM you instrucitons if you like (when i find it on the depths of my PC )

I want it too.

Haha!

(2010-06-24, 05:47 AM)darkly Wrote: [ -> ]You should work on a script to auto reinstall the forum.

(2010-06-24, 06:01 AM)Modv2 Wrote: [ -> ]I'm terrible at php.

No php experinece required. I'll give you what you need!

To start with you will need to export a copy of your database as a sql file. If you have cPanel, Plesk or any other Control Panel, go into it and go into phpMyAdmin, click on your myBB database on the left hand side to open the databse, then at the top click on the Export Tab, select all tables and scroll down towards the bottom and check the Save As File checkbox, name it now go over to the right and click Go, select where you want to download the file to and name it "db_refresh.sql". There's your database backup!

Now you'll need to create a file called db_refresh.php and copy and paste the code below into it, changing the database connection information to your database username, database name, pssword and editing the $site line for your URL:

<?php

	$db_host = 'localhost (Or THE DATABASE ACCESS IF DIFFERENT)';
	$db_user= 'YOUR USERNAME';
	$db_pass = 'YOUR PASSWORD';
	$db_name = 'YOUR DATABASE NAME';
	
	$site = 'http:/YOUR WEBSITE ADDRESS/';

	$dbh=mysql_connect ($db_host, $db_user, $db_pass) or die ('I cannot connect to the database because: ' . mysql_error());
	mysql_select_db ($db_name);

	$sqlfile = "db_refresh.sql";
	$fp = fopen($sqlfile, "rb");
	$buffer = fread($fp, filesize($sqlfile));
	fclose($fp);
	$lines = preg_split("/;/", $buffer);

	foreach ($lines as $line_num => $line) {
		echo $line  . "<br>";
		$result = mysql_query ($line)OR die(mysql_error());
	}
?>

Now you'll place the exported sql file and the ds_refresh file somewhere on your server, in the same folder or directory. You can create a new folder if you want too.

And finally, we will setup a cron job to restore the database at whatever interval you want.

Go back into your Control Panel and find Cron Jobs, open it up and create the Cron Job as follows. In the text box for the Command enter this

php -q /home/YOUR DOMAIN USERNAME/public_html/FOLDER YOU PLACED THE FILES IN/db_refresh.php

Now just select the interval you want to restore our sandbox site and wholla, the forum is back to it's original state on every run of the cron job.

You've given myBB members something great to test plugins and code on, so I'm giving you an easy way to restore it to back to the original.

Wow, thanks! I'll be sure to insert it once I get time.

Where is it? >.>

Where is what?