Saturday, May 4, 2013

Copy mysql database

1. Stop mysql service
sudo /etc/init.d/mysql stop
2. Backup current database
cp -Rp /var/lib/mysql /var/lib/mysql.backup
3. Copy the database
cp -Rp /mountpoint/var/lib/mysql /var/lib/mysql
 4. Start mysql service
/etc/init.d/mysql start

cp
/etc/my.cnf  or /etc/mysql/my.cnf 

No comments: