如果保留 bbs.sql 文件中的 DEFAULT CHARSET=gbk 进行导入,提示如下:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 394: Duplicate entry '2011?' for key 'username'
ERROR 1062 (23000) at line 459: Duplicate entry '1-2011?' for key 'PRIMARY'
ERROR 1062 (23000) at line 2719: Duplicate entry '2011?' for key 'username'
ERROR 3507 (HY000) at line 15639: Failed to update columns dictionary object.
ERROR 1146 (42S02) at line 15659: Table 'bbs.pre_security_evilpost' doesn't exist
ERROR 1146 (42S02) at line 15660: Table 'bbs.pre_security_evilpost' doesn't exist
ERROR 1146 (42S02) at line 15661: Table 'bbs.pre_security_evilpost' doesn't exist
ERROR 1146 (42S02) at line 15662: Table 'bbs.pre_security_evilpost' doesn't exist
<