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

Comments

Popular posts from this blog

CakePHP 4: Firebase Cloud Messaging Component in CakePHP for Push Notification

CakePHP 4 : Using Component inside Command ( Shell )

LIMIT SSH ACCESS BY COUNTRY