Re: Help! i want to clone my Centos machine to another box..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



> 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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux