Navicat how to back up MySQL database

Use software to back up MySQL database (take navicat as an example)

1) Open Navicat---connection---Mysql
2) Fill in the MySQL database connection information

3) Back up the MySQL database file
Double-click to open the created connection---Select the database---Right click---select "Dump SQL file" to export the database to a. sql file

4) Restore MySQL database files
Double-click to open the created connection---Select the database---Right click---select "Run SQL file"
Specifies that the database backup file is encoded with the backup file, and the default selected encoding is 65001 (UTF-8). The GBK code is 936 (Simplified Chinese GBK). The encoding chosen here needs to be the same as the. sql file encoding, otherwise an error occurs.
If the progress bar displays complete and there is no prompt error, the import is successful. Click "Table", press F5 Refresh to see the content after the import

Attention:
Using a client to remotely connect to a MySQL database often prompts you:
ERROR 1129 (00000): Host ' xxx.xxx.xxx.xxx ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts '
This means that there are too many connection errors between the IP and MySQL, which is blocked by MySQL. Default MySQL masks the client IP when there are 10 connection errors.
You need to log in to the server, run
Mysqladmin-u User name-p password flush-hosts
You can connect after you clear the mask.

Above content by the shuttle cat connected cat www.suomao.com in 51CTO blog debut, forwarding please keep the site, thank you!!

This article is from the "Shuttle Cat Interconnection-Kitten" blog, please be sure to keep this source http://suomao.blog.51cto.com/9868774/1608543

Navicat how to back up MySQL database