MyBB Community Forums

(2010-06-27, 07:00 PM)shawn16 Wrote: [ -> ]Where is it? >.>

Everything you need to do is listed in my tutorial.

(2010-06-27, 05:57 PM)mark-in-dallas Wrote: [ -> ]

(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.

OMG!

This is what I'm looking for! :p

Edit:

I got this error.

-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 27, 2010 at 11:50 PM -- Server version: 5.0.90 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */
/*!40101 SET NAMES utf8 */
-- -- Database: `darkly_mybb14` -- -- -------------------------------------------------------- -- -- Table structure for table `mybb_adminlog` -- CREATE TABLE IF NOT EXISTS `mybb_adminlog` ( `uid` int(10) unsigned NOT NULL default '0', `ipaddress` varchar(50) NOT NULL default '', `dateline` bigint(30) NOT NULL default '0', `module` varchar(50) NOT NULL default '', `action` varchar(50) NOT NULL default '', `data` text NOT NULL, KEY `module` (`module`,`action`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
-- -- Dumping data for table `mybb_adminlog` -- -- -------------------------------------------------------- -- -- Table structure for table `mybb_adminoptions` -- CREATE TABLE IF NOT EXISTS `mybb_adminoptions` ( `uid` int(10) NOT NULL default '0', `cpstyle` varchar(50) NOT NULL default '', `codepress` int(1) NOT NULL default '1', `notes` text NOT NULL, `permissions` text NOT NULL, `defaultviews` text NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
-- -- Dumping data for table `mybb_adminoptions` -- INSERT INTO `mybb_adminoptions` (`uid`, `cpstyle`, `codepress`, `notes`, `permissions`, `defaultviews`) VALUES (0, '', 1, '', 'a:5:{s:6:"config"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a:5:{s:6:"config"' at line 6

Glad you could be helped.

Attach or PM me your sql and db_refresh files

(2010-06-28, 05:26 AM)darkly Wrote: [ -> ]OMG!

This is what I'm looking for! :p

Edit:

I got this error.

-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 27, 2010 at 11:50 PM -- Server version: 5.0.90 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */
/*!40101 SET NAMES utf8 */
-- -- Database: `darkly_mybb14` -- -- -------------------------------------------------------- -- -- Table structure for table `mybb_adminlog` -- CREATE TABLE IF NOT EXISTS `mybb_adminlog` ( `uid` int(10) unsigned NOT NULL default '0', `ipaddress` varchar(50) NOT NULL default '', `dateline` bigint(30) NOT NULL default '0', `module` varchar(50) NOT NULL default '', `action` varchar(50) NOT NULL default '', `data` text NOT NULL, KEY `module` (`module`,`action`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
-- -- Dumping data for table `mybb_adminlog` -- -- -------------------------------------------------------- -- -- Table structure for table `mybb_adminoptions` -- CREATE TABLE IF NOT EXISTS `mybb_adminoptions` ( `uid` int(10) NOT NULL default '0', `cpstyle` varchar(50) NOT NULL default '', `codepress` int(1) NOT NULL default '1', `notes` text NOT NULL, `permissions` text NOT NULL, `defaultviews` text NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
-- -- Dumping data for table `mybb_adminoptions` -- INSERT INTO `mybb_adminoptions` (`uid`, `cpstyle`, `codepress`, `notes`, `permissions`, `defaultviews`) VALUES (0, '', 1, '', 'a:5:{s:6:"config"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a:5:{s:6:"config"' at line 6

The problem is, any fields (such as pm views etc) with ";" in the middle of a line breaks the SQL

---

Also you'll want to run a script to delete all the files then unzip a fresh backup

(2010-06-29, 06:58 PM)Tommyk Wrote: [ -> ]Also you'll want to run a script to delete all the files then unzip a fresh backup

How do I do that? :p

You should buy a domain called theforumsandbox.info and have a list of software people can test that resets itself in 12 hours. Both free and paid software testing.

Haha, that'd be a nice idea. I could get Smf and Phpbb too. And, if everyone donated maybe someday IPB and/or VBulletin.

Thanks for the awesome idea. I may actually do that.

Already made it

http://www.forumscommunity.com

Register and click "Create".