备份数据库:
mysqldump -h192.168.42.161 -uroot -ptest1234 scanner > scanner.bak.sql --default-character-set=utf8
mysqldump -uroot -padmin test_database test_table> test_table.sql
注意设置导出的字符集--default-character-set=utf8
导入数据库:
mysql -hhostname -uusername -ppassword databasename < backupfile.sql --default-character-set=utf8
mysql -uroot -padmin scanner < scanner.sql