★ Welcome to The Guardian God · V Classroom, website address: http://v.huweishen.com
★ Guardian God · V Classroom is a Web site dedicated to providing server instructional video for the Guardian God, updated weekly video.
★ This section we will lead you: MySQL database transfer method
This section focuses on MySQL's overall migration approach, and if it's a single database migration, see my other videos.
Operation Process: Back up the "data" directory on the old server, then restore the "data" directory on the new server, and set the permissions
。
1, the old server. Backing up data
Stop the MySQL database service, back up the "data" directory, and transfer to the new server.
2. New server. Restore Backup
New server I have installed the same version of MySQL;
Stop "MySQL" service, rename "data" directory;
Create a new "data" directory and copy the files in the data directory of the backup file;
If the "MySQL" startup account is not "SYSTEM", please note that the "data" directory plus the Full control of this startup account
Permissions.
3. Test Connection
Start "MySQL";
Open "PHPMYADMIN", using the account and password of our old database to login;
Successful login, indicating the success of the transfer machine.
Now that this section is over, please visit the Guardian God website (www.huweishen.com) for more instructional videos.
Reprint please indicate the source (http://v.huweishen.com/video/62.html) Thank you!
[Windows Server 2012] MySQL method of moving the machine