The method of realizing mysql backup and recovery by navicat

This article mainly introduces the method of navicat to achieve mysql backup and recovery, the article is very detailed, has a certain reference value, interested friends must read it!

How to realize mysql backup and recovery by navicat

Recommended: navicat usage tutorial

1. View the data tables in the existing test database

Using navicat to realize mysql backup

1. Click the backup button in the toolbar

2. Click New backup

3. Click to select an object

4. Select the object to be backed up, and click the start button.

5. Start backup

6. When the progress bar runs and the backup ends, click the close button.

7. Backup is successful

Use Navicat to restore database backup

1. Delete the test table and test_3 table in the database

2. Click the backup of the toolbar

3. Find the data you just backed up

4. Select the backup, click restore backup, click the start button in the pop-up window, and click OK in the warning window.

5. Wait for the progress to be completed, and click close.

6. If you look at the database again, you can find that the test table and test_3 table that you just deleted have been restored.

These are all the contents of this article entitled "navicat's method of mysql backup and recovery". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!