1、Got error: 1449: The user specified as a definer ('XXX') does not exist when using LOCK TABLES
如果确定用户权限是对的,可以使用 -x 参数尝试解决
2、Couldn't execute 'XXX': View 'XXXX' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
使用 -f 参数尝试解决
3、Got error: 2006: MySQL server has gone away when selecting the database
在my.cnf的[mysqld]和[mysqldump]下 添加如下配置 max_allowed_packet= 512M,具体大小根据实际情况调整。调整后需重启应用