4.1.1 linux
[1] shell> /mysql/bin/mysqldump -u root
--password=wxbwer mysql user > user.sql
==Mysql 导入
[1]
If you have the database before, e.g. cmdb, you should drop and re-create the
database
- shell> /mysql/bin/mysqladmin –u root
–p drop cmdb
- shell> /mysql/bin/mysqladmin –u root
–p create cmdb
[2] shell> /mysql/bin/mysql –u
root –p cmdb < cmdbxxxx.sql
5.0
导入
D:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -h localhost -u root -p123456 < c:\bbscs8.sql
导出
D:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -h localhost -u root -p123456 databasename > c:\bbscs8.sql