mysql 導入與導出sql文件(備份)
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
導入

導出

posted @ 2008-06-26 08:56 gdufo| 編輯 收藏