错误问题1:

spacer.gifwKiom1cWKBHj0-_NAAAYxUpJE54946.png

解决:

mysql> grant execute on procedure state.proc_order_seller to 'kfdata'@'localhost';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)



错误问题2:

mysqldump: Got error: 1227: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation when doing refresh

解决:权限不够,使用root备份


故障问题3:

mysqldump -uroot -p'123456' -F -B -A|gzip >/data/mysql/backup/mysqlbak_$(date +%F).sql.gz

-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

mysqldump: Got error: 1146: Table 'test.aa' doesn't exist when using LOCK TABLES

解决:

删除/application/mysql/data/test/目录中的AA.frm文件即可


错误问题4:

mysql从库数据同步出错

解决:从库设置跳过错误提示的方法:

stop slave;
set global sql_slave_skip_counter =1;
start slave;