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

«1»

Powered By Z-Blog 2.3 Avengers Build 180518

心众旗下XinFocus'Blog版权所有 © 2008-2030 苏ICP备09039068 E-mail:468007682@qq.com