Mysqldump Export/Import all databases

In the Windows environment

Add "System environment variables". My Computer > Properties > Advanced > environment variable, under the "System Variables" section, find the path double-click Edit. Add, (semicolon), and then add the path to the Bin folder (containing files such as Mysql.exe and Mysqldump.exe) in the MySQL installation directory, such as F:\wamp\bin\mysql\mysql5.0.45\bin.

After that, start > run, enter CMD to open the Command line window,

Be sure to note that this is not a MySQL command, so do not execute under MySQL.

Export all databases:

Mysqldump-uroot-p--all-databases > F:/sqlfile.sql

Import

command line into MySQL, be sure to enter MySQL, this is the MySQL command, and then enter

SOURCE F:/sqlfile.sql

Mysqldump can also back up a database on its own, without showing it.

Mysqldump Export/Import all databases