moving vBulletin to new server?

[Lorina]

Help! I need the Complete and Utter Moron's Guide to Transferring my vBulleting Database to the New Servers. I haven't the first clue about how to use telnet. Is it possible through phpAdmin? Thanks soooo much!!!

[pestilence]

i would probably sayout of all the users on this board that johnm is the man to speak to :)

[Brian Asselin]

If I'm not mistaken you can do it VIA phpMyAdmin by going to "View dump (schema) of database"
and checking off "Structure and data" and "Send" then pressing "Go" a file will start downloading, save it your hard drive go to your new Database (in phpMyAdmin) open the downloaded file in notepad, select it all and paste it into
"Run SQL query/queries on database dbname" or just use the browse button to find it on your hard drive then press "Go"

If I'm wrong someone will point it out :)

[pestilence]

very true but in mysql admin howdo ya import the db back into vbb
i know hows it is done from a shell

[Edited by pestilence on 01-04-2001 at 09:38 AM]

[Lorina]

Thanks! This is working if I do it one table at a time (users, announcements, etc.), except, of course, for the threads and posts. Maybe those files are too large? I have about 10,000 posts and 1,000 or so threads. Would I be better off pruning them?

Thanks again!

[petesmc]

*quoted*Here are some instructions on how to backup your database and move it to the new servers:

1) Log in with SSH.

2) Type:

/usr/local/mysql/bin/mysqldump -p$yourpassword $databasename > $filename.sql

3) Then download the $filename.sql in ASCII mode. Making sure that you download it in ASCII mode is very important.

4) Upload the file to the new server, again in ASCII mode.

5) Go to the directory that you uploaded the file into and type:

mysql -p$yourpassword $databasename < $filename.sql

6) You're all done. You're database has been imported.

*/quoted*

[pestilence]

http://www.vbulletin.com/forum/showthread.php?threadid=2199

step by step on how to do it :)