Backup and restore of MySQL data

Backup Db_book: here to use the CMD, run as Administrator, or later use mysqldump will be denied access!!!

1. Start cmd, enter the command, switch to the MySQL bin file:

2. Then enter the backup command:

Backup Good SQL library:

The other is to use software backup method:

Select Export to Desktop or other location:

Click Export to complete the backup:

The second method of software backup is generally recommended, which is simple and efficient.

Export tables: How to use the software.

Export format and save location selection:

Click Export to finish:

Double-click to open, see:

Next is the data restore:

It is recommended to use the graphical interface to restore, the command is more cumbersome:

Assuming that T_book was deleted by you, now you want to restore it, the steps are as follows:

Select the files you want to restore:

Click Execute: The library is imported here.

T_book has been restored back again.

Backup and restore of MySQL data