Export/import table structure and data from MySQL with commands

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
Eg:

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

Sometimes, import data into the MySQL import, write an importer, write a Java script implementation can be.