Under Windows, import the MySQL offline data file into the local MySQL database

1.View MySQL path

SELECT @ @basedir as BasePath from DUAL

In fact, mysql5.6 data files in

C:\ProgramData\MySQL\MySQL Server 5.6\data (hidden)

2.Stop MySQL service

3. put the database you want to import into the Data folder

4. RestartMySQL service

After a successful restart, the Discovery table import, but can not open (open error);

5. Deleting log files and replacing Ibdata1

Restart the database again and find the import data successful!

Note: If you have a database of your own previously built error (because the replacement of ibdata1), you need to back up the previous database you built;

Under Windows, import the MySQL offline data file into the local MySQL database