Added by Mario Borgnia almost 11 years ago
Hi Anchi,
Thank you for all the help!
I would like to take a snapshot of the database. Also, I would like to be able to migrate it to a different host. What is the best way to accomplish that?
Thanks
Mario
mysqldump is the best option.
You can use the instruction in How_to_Update_from_v22_(Linux).
If you know database structure well enough, you can also rsync the files for backup purpose. However that is not advisable if you need to migrate to a computer with different mysql version.