Moving MySQL db's
 

I'm moving servers and need to move several databases

Can anyone point me to some tutorials to make this as easy and pain free as possible ?

just dump the databases and recreate them on the new server - if you are using a tool like phpMyAdmin, then it is easy unless your db's are of a kind i dont know about...

If it's a large database, I don't know how well PHPMyAdmin will do with dumping it. I would do it using telnet if I was you. Just dump it to a directory, then copy it to your new server and recreate it there.

Looking.... I just found it. Here is a detailed page on how to move a MySQL database from one server to another:

http://www.vbulletin.com/manual/movingservers.html

Thanks mr fiction

that should be enough to get me started, I'll bumble my way through learning as i go.

Just moved a server with a load of MySQL stuff on it. We used phpmyadmin as it made life soooo much easier.

Ted
A lot of the better hosting companies out there will move your db's for you if you ask. If you have a cut rate host who only wants to hear from you when you send money then the advice others have given is at least on the right track.
I know I recently moved some db's from one server to another and I just asked my host to do it and a few minutes later it was done. Call me lazy if ya want:2 cents:

kicks

You would have to use mysqldump in order to dump the data and the structure, and mysql to import the database from the .sql file created on your new server.

telnet or ssh into your box, and you would need to execute this line from your command line

mysqldump -u username -p --opt databasename > backup-file.sql

You will be asked for your password, then, move the backup-file.sql to your new server, and create a new database , then use the mysql command to import the file into your new database

mysql -u username -p databasename < backup-file.sql


HIt me up via icq at 118997859 if you have any further problems.


Midnight