Mysql Import and export table structure and data

1. Export the entire database

Mysqldump-u User name-p password database name > exported file name
C:\users\jack> mysqldump-uroot-pmysql Account > E:\account.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 CH_ZHONGYUE_DRG account> e:\account.sql

3. Export a database structure
c:\users\jack> mysqldump-uroot-pmysql-d CH_ZHONGYUE_DRG > E:\drg.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 Import and export table structure and data