Mysql,mysqldump Command Import Export table structure or data

At the command line MySQL data export has a very good command mysqldump, it has a lot of parameters, you can view:
Mysqldump

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

[[email protected] ~] #mysqldump-uroot-pmysql sva_rec date_drv >/opt/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  
[[email protected] ~]# mysqldump-uroot-pmysql sva_rec& nbsp >/opt/sva_rec.sql 

2. Export a table, including the table structure and data  

mysqldump-u user name-p password   database name Table name > exported file name  　　
[[email protected] ~] #mysqldump-uroot-pmysql sva_rec date_rec_drv>/opt/date_rec_drv.sql 

3. Export a database structure  
[[email protected] ~] #mysqldump-uroot-pmysql-d sva_rec >/opt/sva_rec.sql 

     4. Export a table with only the table structure  

Mysqldump-u User name-p password-d database name Table name > exported file name
[[Email protected] ~] #mysqldump-uroot-pmysql-d sva_rec date_rec_drv>/opt/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,mysqldump Command Import Export table structure or data