help

[kantipur]

I m hosting my website in a new web server. There is mysql database in my old server which I want to transfer in my new server.How can I do that???

[bathurst_guy]

You need to export it all, the table structure and all the data, and then import it on the new one. Do you have phpMyAdmin? Install this on both sides and it makes using a MySQL database so much easier (it gives you a friendly web based interface).

[kantipur]

Can't I backup the database from the old server and restore it in the new server? If I can what's the sql command to backup and restore the database?

[chazzy]

exporting it is the same as taking a backup. mysql has a separate utility named mysqldump that creates the backup.