Showing posts from June, 2014

Restore MySQL database files from one server to another

You should be able to restore by copying them in your database folder.
You should copy ibdata files too.

You should do it while the server is not running.

MySQL data files is in /var/lib/mysql/

Terminal command:

     sudo service mysql stop

     sudo cp -Rp /old/databasefolder/databasename  /var/lib/mysql/

     sudo service mysql start