坑爹的是mysqldump能导出来,不知道为啥到不进去,纠结了半天,直接mysql就导入了
导出:mysqldump -h 127.0.0.1 -uroot -pdzl ecshop> /home/ecshop-12-16backup.sql
如果在win7下远程备份,可能没有设环境变量,cd 到C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin下执行mysqldump -h 127.0.0.1 -u** -pdzl ecshop> /home/ecshop-12-16backup.sql
注:不要用root用户,结尾没有";"
导入:mysql -h 127.0.0.1 -uroot -pdzl ecshop < /home/ecshop-12-16backup.sql
不是在mysql环境下,直接在ssh下或cmd下,不要进mysql
例子:
mysqldump 127.0.0.1-u111 -p111 ecshoptest>d:\ecshop-3-13backup.sql
mysql -h 127.0.0.1-u111 -p111 ecshoptest < d:\ecshop-3-13backup.sql
备忘