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