Shulou(Shulou.com)06/01 Report--

1. First find the Data file on the migration server, I installed mysql5.7, the default installation path. So in the C:\ ProgramData\ MySQL file, open the hidden file first.

This Data file is your data file; put the database file you want to migrate here as follows:

Then open my.ini: find datadir, and copy your Data file path below. Use the address of any Data file you want to launch. There can only be one. As follows:

Then restart the MySQL service as follows:

Then open the database connection tool, I use the Navicat here, you connect to the migration database, is your password before the migration.

Summary

The above is the whole content of this article. I hope the content of this article has a certain reference and learning value for everyone's study or work. Thank you for your support. If you want to know more about it, please see the relevant links below.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.