[CentOS] Help! i want to clone my Centos machine to another box..

Mathieu Baudier mbaudier at argeo.org
Thu Oct 22 13:32:37 UTC 2009


> 1. backing up my mysql databases  is it enough to cp /var/lib/mysql and
> /user/lib/mysql or i have to export them? and if thats the case how can i
> export?

For MySQL backups I use the mysqldump utility, which dumps the data as
pure SQL.
This may not be the best option if you have a huge amount of data though.

/usr/bin/mysqldump --lock-tables --add-locks --add-drop-table -u root
--databases my_database > my_database-091021.sql


More information about the CentOS mailing list