Web Hosting Talk







View Full Version : Transfer MySQL DB from server to server...


mercury
01-29-2002, 08:36 AM
is there an "easy" way to transfer a mySQL DB from a CPanel account into another CPanel account (from server to server)?


Thanks for help

kmh
01-29-2002, 08:43 AM
I guess that depends on your definition of "easy".

To me, the easiest method is to do a dump of the DB on the 1st server (either through phpmyadmin or using the shell). Then, create the database on the 2nd server and use the file you created to populate the database.

mercury
01-29-2002, 09:46 AM
ok :)
Easy means.. (for me) that i never done a MySQL DB befor....

kmh
01-29-2002, 12:32 PM
Hmm... Maybe the "easiest" method, then, would be to contact the new host and ask if they will transfer the database for you?

If not, I would ask the host of box1 for help "dumping" the database to a .sql file.

Then, ask the host of box2 for help installing the .sql file into a new database.

The Prohacker
01-29-2002, 01:03 PM
vBulletin has a decent howto:
http://www.vbulletin.com/manual/movingservers.html

Just follow steps 1 to 4....