MySQL command exports database table data

Most commonly used:
Mysqldump-uroot-pmysql databasefoo table1 table2 > Foo.sql

This allows the database Databasefoo table Table1,table2 to be imported as SQL Foo.sql, where the-uroot parameter indicates that the user name that accesses the database is root, and if there is a password, add the-p parameter

c:\users\jack> mysqldump-uroot-pmysql Sva_rec date_drv > E:\date_drv.sql

MySQL data import is also very convenient, such as:
Mysql-uroot Databasefoo < Foo.sql

This allows you to import all foo.sql data into the database Databasefoo

1. Export the entire database

Mysqldump-u User name-p password database name > exported file name
c:\users\jack> Mysqldump-uroot-pmysql sva_rec > E:\sva_rec.sql

2. Export a table, including table structure and data

Mysqldump-u User name-p password database name table name > exported file name
c:\users\jack> mysqldump-uroot-pmysql Sva_rec date_rec_drv> e:\date_rec_drv.sql

3. Export a database structure
c:\users\jack> mysqldump-uroot-pmysql-d sva_rec > E:\sva_rec.sql

4. Export a table with only a table structure

Mysqldump-u User name-p password-d database name Table name > exported file name
c:\users\jack> mysqldump-uroot-pmysql-d Sva_rec date_rec_drv> e:\date_rec_drv.sql

5. Import the database

Common source Commands
Go to MySQL Database console,
such as Mysql-u root-p
Mysql>use Database
Then use the source command, followed by the script file (for example, the. SQL used here)
Mysql>source D:wcnc_db.sql

MySQL command exports database table data