Home  >  Article  >  Database  >  How to restore tables deleted by navicat

How to restore tables deleted by navicat

angryTom
angryTomOriginal
2019-08-06 14:49:5335973browse

How to restore tables deleted by navicat

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"

How to restore tables deleted by navicat

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

How to restore tables deleted by navicat

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

How to restore tables deleted by navicat

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

How to restore tables deleted by navicat

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.

How to restore tables deleted by navicat

How to restore tables deleted by navicat

#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.

How to restore tables deleted by navicat

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn