Troubleshoot MySQL database command import issues

show databases; #查询库表
Use Dataplatform; #进入数据库
Show tables; #查询表
TRUNCATE TABLE wp_comments;# clears tables, wp_comments, empty table names.
Source/root/test.sql; # import data

Error:

Mysql> Source/root/test.sql;
ERROR 1366 (HY000): Incorrect string value: ' \xc9\xcf\xba\xa3\xca\xd0 ... ' for-column ' address ' at

Row 1
ERROR 1366 (HY000): Incorrect string value: ' \xc9\xcf\xba\xa3\xca\xd0 ... ' for-column ' address ' at

Row 1
ERROR 1366 (HY000): Incorrect string value: ' \xc9\xcf\xba\xa3\xca\xd0 ... ' for-column ' address ' at

Row 1
ERROR 1366 (HY000): Incorrect string value: ' \xc9\xcf\xba\xa3\xca\xd0 ... ' for-column ' address ' at

Row 1

Workaround:
Set names GBK;

Troubleshoot MySQL database command import issues