先cd 到D:\wamp\bin\mysql\mysql5.5.24\bin 目录下
(个人经验 win+r ->cmd ->cd e:\wamp\bin\mysql\mysql5.5.24\bin ->e: ->mysqldump --default-character-set=gb2312 -hlocalhost -uroot -p phpjin>d:\test.sql)
导入:(个人经验 win+r ->cmd ->cd e:\wamp\bin\mysql\mysql5.5.24\bin ->e: ->mysql --default-character-set=gb2312 -hlocalhost -uroot -p phpjin
远程导出:
mysqldump -P [端口] -h [IP] -u [用户] -p test>d:\test.sql
例如:
mysqldump -P 3306 -h 192.168.1.224 -u root -p test>d:\test.sql
远程导入:
mysql -h[IP] -P[端口] -u[用户] -p test
例如:
mysql -h 192.168.1.224 -P 3306 -u root -p test
附:
远程导出数据库: mysqldump -h[hosname] -u[user_name] -p[password] --default-character-set=[char_set_name] [db_name] > [save_path]例:然后输入:mysqldump -h119.12.12.11 -umysql-pmysql123--default-character-set=utf8 aspchina