PDA

View Full Version : How to do the mysql conversion from vb v3.5.6 to v3.6.0?


websissy
Thu 18th Sep '08, 5:35pm
I have two sites that were upgraded from vbulletin 3.0.8 to 3.5.8 at the end of March. I couldn't go further at the time because my old web host had no intention of supporting any version of mysql after 3.23.54 on my old RH 7.2 server.

So, now I've bought a new server that's running mysql v5.0.32 with php v5.2.0. I'm ready to move the sites to the new server and the new database manager but need some guidance from someone who has been here and done this on how to proceed. I've searched for threads on this topic but find the forums remarkably (or perhaps I should say, ominously) silent on this subject.

Yet, clearly 1,000's of vbulletin admins have already been through this process.

Should I expect to be able to just export my vbulletin database and all of its tables from the old mysql database and then import them later on the new one using mysql to get them converted to the new DB format? Or will it be considerably more complicated than that?

Can someone here point me to threads on this subject? My searches turned up nothing at all.

Thanks.

Steve Machol
Thu 18th Sep '08, 5:41pm
I would first move your forums and databases, make sure they are working on the new server, then upgrade normally.

Instructions for moving servers are in the online manual here:

http://www.vbulletin.com/docs/html/moving_servers

Note: The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you do not have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump (restore only):
http://www.ozerov.de/bigdump.php