1. 导入,导出时避免中文乱码:
导出:
mysqldump -uroot -p --default-character-set=utf8 mo(dbname) > E://xxxx.sql
导入:
mysql -u root -p --default-character-set=utf8
use dbname
source /root/newsdata.sql
1. 导入,导出时避免中文乱码:
导出:
mysqldump -uroot -p --default-character-set=utf8 mo(dbname) > E://xxxx.sql
导入:
mysql -u root -p --default-character-set=utf8
use dbname
source /root/newsdata.sql
转载于:https://my.oschina.net/u/2422219/blog/523113