MySQL how to back up and import a database

This article is mainly to share with you how MySQL database backup and import, hope to help everyone.

Back up all databases
The system command line executes:mysqldump -uusername -ppassword --all-databases > all.sql

Backing up a single database
The system command line executes: mysqldump -uusername -ppassword --databases db1 db2 > db.sql
Export DB1 and DB2 to a db.sql file.

Import Database
1. System command line execution: mysql -uusername -ppassword db1 < db1.sql
In this case, the DB1 database must be built in advance.
2. Or under MySQL command line execution: source db1.sql
In this way, you do not need to create the database beforehand, and the database is created automatically.