[Windows Server 2008] MySQL Single Database Migration method

★ 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 migration method
Note: This method is only available for MyISAM mode databases (such as the Guardian God · PHP suite); InnoDB is not suitable for this method.
This section focuses on a single database migration, and if it's a MySQL overall migration, check out my other videos.
Operation Flow: Back up the database on the old server, then create the database on the new server, and then restore the data.

1. Find the database path
Open the Services panel, locate the MySQL service, and view the properties.
In My.ini to find the "DataDir" parameter, the following path is the database storage directory.

2. Backing Up the database
Stop the MySQL database service and back up the database that needs to be transferred.


3. Create a new database
The new server is already installed with the new MySQL;
Go to "Guardian God Host management system" backstage, point to the left of "MySQL management", create a new database.

4. Restore Database backup
Follow the 1th step method to find the database path;
Copy the backup file on the old server, overwriting the recovery to the corresponding database.

5. Test Connection
Open "PHPMYADMIN" and log in using the account and password we set when we opened the database.

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/60.html) Thank you!

[Windows Server 2008] MySQL Single Database Migration method