The import and export of MySQL scripts under Linux

1. Export the entire database

Mysqldump-u user name-p database name > exported file name

Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql

2. Export a table

Mysqldump-u user name-P database name Table name > exported file name

Mysqldump-u wcnc-p SMGP_APPS_WCNC users> wcnc_users.sql

3. Export a database structure

Mysqldump-u wcnc-p-d–add-drop-table SMGP_APPS_WCNC >d:\wcnc_db.sql

-D No data –add-drop-table add a drop table before each CREATE statement

4. 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/home/pt/test.sql
　　

Command: mysql-h localhost-u root-p Temp

mysql-h localhost//database address localhost
-U root//user name is root
-p//password enter only after press ENTER

The import and export of MySQL scripts under Linux