MySql Database transfer from one server to a remote server

[Guest_imported]

I have a database ready in Mysql.I have to host my site at the remote server which provides the Mysql database in Linux.Now I want to transfer my entire db out there with the data in it.Can any one tell me how it can be done.thanxs in advance.

 

[devnull22]

If you have access to the MySQL data directory (where the database files are located). You can just tar the entire directory from one server to another.

else use the 'mysqldump' utility.

mysqldump --opt database > backup-file.sql

You can read this back into MySQL with:

mysql database < backup-file.sql

cheers devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !