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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s