[root@hch_test_121_91 ~]# mysql -uroot -p --default-character-set=utf8 </tmp/alldb.sql
Warning: Using a password on the command line interface can be insecure.
Enter password:
ERROR 1142 (42000) at line 18973: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'
Warning: Using a password on the command line interface can be insecure.
Enter password:
ERROR 1142 (42000) at line 18973: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'
[root@hch_test_121_91 ~]#
解决办法:
mysqldump不成功,网上说应该用mysqldump -uroot -p --default-character-set=utf8 --skip-lock-tables --single-transaction --events --all-databases >alldb.sql重新备份下,就可以重新导入进来了。
貌似也失败了。