Windows下使用mysqldump命令导入/导出.sql文件
备份
mysqldump -u databasename -p -h localhost databasename>d:\demo.sql
还原
mysql -h localhost -u root -p123456 databasename<d:\demo.sql
备份
mysqldump -u databasename -p -h localhost databasename>d:\demo.sql
还原
mysql -h localhost -u root -p123456 databasename<d:\demo.sql