MySQL (5.0) Export and Import

Export command:

Mysqldump-uroot-proot-r -- databases db1 DB2 -- result-file = C:/123. SQL -- default-character-set = GBK

-R: including storage in the exported SQLProgramAnd user-defined functions;

-- Databases XXX: includes several databases. Create Database if not existsDb_nameAnd useDb_nameThe statement is included in the output before each new database;

-- Result-file = xxx: the exported SQL is saved to XXX;

-- Default-character-set = xxx: the exported SQL format is XXX (GBK, utf8...). If not specified,MysqldumpUse utf8.

 

Import command:

Mysql-uroot-proot <C:/123. SQL