Upgrading 'manually'

[Arkidas]

My database is not very healthy and as I tried to upgrade 'automatically' ( like in the vBulletin ReadMe ) I got many SQL errors during upgrade and after the upgrade the forum isn't stable.

I made a backup before upgrading so I'm all safe, but I think it may be a better idea to set up a fresh 3.7 forum and them import the important tables back like posts, users etc.

What I need is a list of important tables, can you give me one?

[snakes1100]

Why dont you post the database error you got and the current issues your having, that way we can help you fix the current issues.

If you want to setup a new forum/db, then use Impex provided by vb.com and just let it handle the import of all important info to the new forum for you.

[Arkidas]

Can you explain how to do this with ImpEx?

This was the first error I got:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE userlist ADD friend ENUM('yes', 'no', 'pending', 'denied') NOT NULL DEFAULT 'no';

MySQL Error : Table 'blizzard_vbulletin.userlist' doesn't exist
Error Number : 1146

[Marco van Herwaarden]

I don't suggest using ImpEx for this.

Please:
- Restore your backup
- Start the upgrade process again, and stop on the first error!
- post the error you get.

[Arkidas]

Ok. The back up stands of over hundred .SQL files, one for each table. What is the easiest way to restore the backup? I tried zipping the SQL files together and then uploading the ZIP file but that resulted in only the adminlog table being restored.