Quote:
Originally posted by Armed & Hammered
/path/to/bin/mysql -u $mysqlusername -p$mysqlpassword $mysqldatabasename < $file.sql
And there is no need to shut down mysql to dump the DB.
|
Please give me an example of how to dump the file.sql with mysqldump command. I am not sure which options to use. Should I use "--add-drop-table"?
I do not want to delete the databases, I just want a perfect copy of them for the new server.