MySQL several common commands under the Operation Database command

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

Organize yourself:

@ Connect to Database:
/usr/bin/mysql--default-character=utf8-uroot-p ' xxx '-hyyy-pzzz VVV

@ Set up XXX database

MySQL--default-character=utf8-uroot-p123-h192.168.0.14-p3300 < "F:\tool\dict_bat\create_db.sql"

@ Execute a script on the specified database (scripts such as table updates)
MySQL--default-character=utf8-uroot-p123-h192.168.0.14-p3300 vvv < "F:\tool\dict_bat\xxx.sql"

@ from the specified database to the table (table structure and table data)

mysqldump--default-character=utf8-uroot-p123-h192.168.0.14-p3300 vvv xxx table > "F:\tool\dict_bat\xxx.sql"---to test

@ Export tables from the specified database (table structure)-D is a table-only mechanism

mysqldump--default-character=utf8-uroot-p123-h192.168.0.14-p3300-d vvv xxx table > "F:\tool\dict_bat\xxx.sql"---to test

@ Export the specified database (table structure and table data)

Mysqldump--default-character=utf8-uroot-p123-h192.168.0.14-p3300 vvv > "F:\tool\dict_bat\xxx.sql"---to test

@ Export specified database (table structure)-D is a table-only mechanism

Mysqldump--default-character=utf8-uroot-p123-h192.168.0.14-p3300-d vvv > "F:\tool\dict_bat\xxx.sql"---to test

MySQL several common commands under the Operation Database command