How to move MySQL database from one server to another

First access the files of the database (MYI, MYD, FRM) from the existing database by going to
/var/lib/mysql/(your database) – This path holds true for ubuntu

Then go to the new server and put it in the same place

/var/lib/mysql/(your database).
restart your server and mysql then view it through phpmyadmin.

One Comment

    Cannot find .frm file – mysql error « Gullele’s Corner

    […] find .frm file – mysql error By gullele Especially when you move mysql from Window [see related] to Linux using the data file copy, you might face such and error telling you one of your […]

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*