March 6th, 2000, 11:43 PM
When I move my site which uses a MySQL database, how would I move the whole database from the old MySQL server to the new one?
March 7th, 2000, 09:13 AM
You could use mysqldump to export the current db to textfile format, and import the output from mysqldump on your new server using the following:
mysqldump -p mydb --add-drop-table > mydb.sql (on your current server)
then upload the file mydb.sql to your new server (you could use gzip to compress it)
mysql -p mydb < mydb.sql (on your new server)