How to export a mysql database from the command line

MySQL exports the specified data table and data [command].

mysqldump -u username -p databasename > the name of the exported file.

1. The mysqldump command backs up the data.

MySQL provides a convenient tool for exporting database data and files from the command linemysqldump, we can directly export the database content through the command line, first of all, let's briefly understand the usage of the mysqldump command

Mysqldump is commonly used.

mysqldump -u root -p --databases database 1 database 2 >

2. Mysqldump common operation examples.

Back up the data and structure of all databases.

mysqldump -uroot -p123456 -a > data/mysqldump/

Back up the structure of the entire database (plus the -d parameter).

mysqldump -uroot -p123456 -a -d > data/mysqldump/

Back up the data of all databases (add the -t parameter).

mysqldump -uroot -p123456 -a -t > data/mysqldump/

Back up the data and structure of a single database (database name mydb).

mysqldump -uroot-p123456 mydb > data/mysqldump/

Back up the structure of a single database.

mysqldump -uroot -p123456 mydb -d > data/mysqldump/

Back up data from a single database.

mysqldump -uroot -p123456 mydb -t > data/mysqldump/

Back up the data and schemas of multiple tables (the same as the above describes the separate backup method for data and schemas).

mysqldump -uroot -p123456 mydb t1 t2 > data/mysqldump/

Back up multiple databases at once.

mysqldump -uroot -p123456 --databases db1 db2 > data/mysqldump/

1. The mysqldump command backs up the data.

MySQL provides a convenient tool for exporting database data and files from the command linemysqldump, we can directly export the database content through the command line, first of all, let's briefly understand the usage of the mysqldump command

Mysqldump is commonly used.

mysqldump -u root -p --databases database 1 database 2 >

2. Mysqldump common operation examples.

Back up the data and structure of all databases.

mysqldump -uroot -p123456 -a > data/mysqldump/

Back up the structure of the entire database (plus the -d parameter).

mysqldump -uroot -p123456 -a -d > data/mysqldump/

Back up the data of all databases (add the -t parameter).

mysqldump -uroot -p123456 -a -t > data/mysqldump/

Back up the data and structure of a single database (database name mydb).

mysqldump -uroot-p123456 mydb > data/mysqldump/

Back up the structure of a single database.

mysqldump -uroot -p123456 mydb -d > data/mysqldump/

Back up data from a single database.

mysqldump -uroot -p123456 mydb -t > data/mysqldump/

Back up the data and schemas of multiple tables (the same as the above describes the separate backup method for data and schemas).

mysqldump -uroot -p123456 mydb t1 t2 > data/mysqldump/

Back up multiple databases at once.

mysqldump -uroot -p123456 --databases db1 db2 > data/mysqldump/