frm

Restore data from frm files mysql

Posted on Updated on

1. Stop service mysqld
2. cp -R /old/var/lib/mysql/your_db /var/lib/mysql
chrown -R mysql:mysql /var/lib/mysql/your_db
cp /old/var/lib/mysql/ibdata1, ib_logfile0, ib_logfile1 /var/lib/mysql
override? yes
3. start service mysqld
4. Done

Advertisements