If the mysql database data is damaged or lost for some reason, if there is a backup, we can restore the previously backed up database backup. If there is no backup, it may be more troublesome, and the cost of retrieving data is also very high. Let’s introduce how to restore database files for mysql database
Recommended tutorial:MySQL introductory video tutorial
1. Open the navicat tool, connect to the mysql database, and select a database (for demonstration purposes, we select a test database here). In the menu bar above, select Backup, then select a backup file in the backup list and click "Restore Backup"
2. In the restore backup dialog box, by default General options are displayed, which displays detailed information about the backup file. Pay attention to checking the information and time point here, and restore to the wrong version
3. Switch to the "Select Object" option and check the data objects that need to be restored. By default, all Check it and restore it in full
4. Switch to the "Advanced" option. You can check the corresponding options for server options and object options. If you don't want to overwrite the existing For some functions, just remove the corresponding check box
5. After the configuration check is completed, the information confirmation is completed. You can click the "Start" button to restore the backup. There will be a confirmation dialog box here, click to confirm development recovery. After the recovery is completed, "[Msg] Finished - Successfully" will be prompted in the log message, indicating that the recovery is complete.
#6. For backup files, in addition to choosing to restore the backup, you can also choose "Extract SQL". This function can be obtained from Extract the sql statement from the previous backup file, and then select the corresponding data from the sql statement for incremental recovery or for data comparison.
The above is the detailed content of How to restore tables deleted by navicat. For more information, please follow other related articles on the PHP Chinese website!