XinFocus'Blog 聚焦互联网技术_网络营销推广_工商财税_知识产权_商标专利_苏州创客_创业政策_美文分享

windows下cmd导入与导出mysql数据库

CMD下MYSQL数据库导出方法:

mysqldump -u root -p xinfocus1 >e:\xinfocus1.sql
mysqldump -u root -p xinfocus2 >e:\xinfocus2.sql
mysqldump -u root -p xinfocus3 >e:\xinfocus3.sql
解除锁定
mysqldump -u root -p xinfocus1 --skip-lock-tables >e:\xinfocus1.sql
mysqldump -u root -p xinfocus2 --skip-lock-tables >e:\xinfocus2.sql
mysqldump -u root -p xinfocus3 --skip-lock-tables >e:\xinfocus3.sql