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
Post a Comment

Popular posts from this blog

CakeAdminLTE is based on AdminLTE Theme for CakePHP 2.4+

CakePHP: COUNT data and GROUP BY date

CakePHP: Calling function from other controller