Implementation of restoring data by directly copying files in the data directory in mysql

mysql copies the files in the data directory to restore the data

Background: MySQL crashed and could not be started. I decided to rebuild the environment, but I forgot to back up the database test data. The MySQL data directory survived.

operate:

1. Copy the folder of the test database (including .frm .ibd and other files)

2. Restart MySQL

When viewing a table in the database through Navicat, the result shows "Table 'xxx' does not exist"

3. After searching on Google and Baidu, I found the innodb table

Directly copying the file is not usable, and it will prompt that the table does not exist. When copying, the ibdata1 file in the data directory should be copied together, and the ib_logfile0, ib_logfile1 and other files should be deleted.

mysql migrates the database by copying data files

1. Shut down the service

Run cmd as an administrator and execute the following command:

net stop mysql

2. Copy data files

Copy the database file of the data file (no need to copy mysql, performance_schema, sys), and be sure to copy the ibdata1 file

3. Import files

Put the copied file into the data file of the destination database

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.