Database Migration Problems

[snunhuck]

Hi,

I've just migrated my database from a backup as there was a small problem on the server that corrupted all the database beyond repair.

Unfortunately, the database is showing up as version : vBulletin 3.7.0 Release Candidate 3

I know for a fact that it was STABLE before the backup so as to why it's showing up like that is a complete guess....

I'm trying to upgrade now and as all the files are in place (3.7.2 PL2) It's telling me that I'm upgrading to RC4

I was on 3.7.2 PL1 before the database was corrupted.

Here's what happens when I try to run the upgrade script:

Step 1) Critical Template Changes

Adding required security token to 0 customized template(s)
Altering setting Table (1 of 1)
Database error

DB Error:
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:

INSERT INTO upgradelog(script, steptitle, step, startat, perpage, dateline)
VALUES ('upgrade_370rc4.php', 'Critical Template Changes', 1, 0, 0, 1219576923);

MySQL Error : Table 'forum.upgradelog' doesn't exist
Error Number : 1146
Request Date : Sunday, August 24th 2008 @ 06:22:03 AM
Error Date : Sunday, August 24th 2008 @ 06:22:03 AM
Script : http://site/forum/install/upgrade_370rc4.php?step=1
Referrer : http://site/forum/install/upgrade_370rc4.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Marco van Herwaarden]

If your board is showing as 3.7.0RC3 after you restore the backup, then this backup was created when the board was running that version.

About your upgrade error, can you verify that this table is missing, was it restored from the backup, are you using table prefixes?

[snunhuck]

I am not using table prefixes and the table is missing. It does not exist on the backup on the other server either.

[Marco van Herwaarden]

Is this the only missing table? And why is it missing from the source/backup?

[snunhuck]

I have 175 tables but I'm sure that there were more than that the last time I used that copy of the database.

I've a lot of users and things in that database - should I just do a fresh install and import the database?

[Marco van Herwaarden]

A fresh install would not help much. You will need to find a complete backup.

PS If it is only the 'upgradelog' table that is missing, then you might be able to use an older backup for this table. If you have done any upgrades since that other backup was made, then you will need to update the contents of the file accordingly.

[snunhuck]

I don't know how many tables there are in a fresh installation so I can't compare.

--------------- Added 1219603316 at 1219603316 ---------------

Here's what's missing:

regimage NOT found.
templatehistory NOT found.
thread NOT found.
threadrate NOT found.
threadread NOT found.
threadredirect NOT found.
threadviews NOT found.
upgradelog NOT found.
user NOT found.
useractivation NOT found.
userban NOT found.
userfield NOT found.
usergroup NOT found.
usergroupleader NOT found.
usergrouprequest NOT found.
usernote NOT found.
userpromotion NOT found.
usertextfield NOT found.
usertitle NOT found.
word NOT found.

[Marco van Herwaarden]

Well then you have a serious problem as some key tables like 'thread', 'user' & 'usergroup' are missing. No way you can restore your board without those tables.