Moving a mySQL database??

[luchazard]

Ok here is the deal. I have a site and most of the content is called in with PHP scripts and I have everything stored in mySQL. I'm going to switch to a different host soon... does this mean I will have to write my database all over again from scratch?? Or can I transfer it some how?

Thanks!

[James]

If you have telnet access to both hosts, log into telnet and type this on the old host:

mysqldump -uyourusername -p yourdatabase > /path/to/file.sql

Then download the file.sql and upload it to your new host, and type this:

mysql -uyourusername -p yourdatabase < /path/to/file.sql

I'm not 100% sure of the syntax of the second one but it should be OK.

[DCE]

No need to log into both hosts..
just FTP into your new host from the Telnet window of the old one, then just send the file that way
very quick, using their connection

[luchazard]

YES! I'm glad it will be an easy move!

Thanks for your help.