Backup Problems

[Devilbrad]

I've been working on this with another member but thought I might get other opinions in this thread. Here's the recap, our forum is on 3.8.6 and im upgrading it to 4.x but setting up a test site first. Right now its at 4.0x but will soon go to 4.2.

I had the new forum installed and working and have been trying to restore it to show all our forum names etc while I play with getting it ready. I first tried to back it up using the CPanel backup, then used phpmyadmin. Neither worked due to timeout reasons.

Last night I tried with bigdump. Changed the URLs, exported with phpmyadmin, had the "ADD DROP TABLE" setting checked. Changed the bigdump.php DB config, uploaded and ran it as they said. I got:

Stopped at the line 410.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts or very long procedure definitions. Please read the BigDump usage notes for more infos. Ask for our support services in order to handle dump files containing extended inserts.

So I created another backup with just structure (no data) and in .gz. Ran bigdump etc. Said that it worked ok but now the forum is messed up and says:

vBulletin datastore error caused by one or more of the following:
You may have uploaded vBulletin files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.

Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 247

So I run the install/upgrade.php and the URL gets changed to install/upgrade_363.php. Went around in circles upgrading to 3.63, 3.64, 3.65.... till 3.7, then got this error in Step 2) Altering Table Defaults

Database error in vBulletin :

Invalid SQL:
ALTER TABLE groupmessage
CHANGE groupid groupid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postuserid postuserid INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE postusername postusername VARCHAR(100) NOT NULL DEFAULT '',
CHANGE dateline dateline INT UNSIGNED NOT NULL DEFAULT '0',
CHANGE ipaddress ipaddress INT UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Unknown column 'groupid' in 'groupmessage'
Error Number : 1054
Request Date : Friday, February 21st 2014 @ 11:18:27 AM
Error Date : Friday, February 21st 2014 @ 11:18:27 AM
Script : http://www.racemagnum.com/thefogpoun...0b3.php?step=2
Referrer : http://www.racemagnum.com/thefogpoun...0b3.php?step=1
IP Address : 24.92.208.4
Username :
Classname : vB_Database
MySQL Version : 5.5.32-31.0-log

Please help! I have no idea how im messing up a simple DB backup so bad!

[RichieBoy67]

You can't use a back up with no data and only structure. This is why you get the datastore error.

It sounds like you need to start over with this upgrade. Do your database using ssh if possible and use it to import as well. Then upload your fresh files over the old ones on your test site ofcourse and try again. Do the whole upgrade though at once and not in steps. I mean I know it goes through steps but go to completion.