mysqldump: Got error: 1449: The user specified as a definer ('yunuser'@'%') does not exist when using LOCK TABLES
導出數據庫時,因視圖/存儲過程/觸發器的 DEFINER 用戶(如 yunuser@%)已被刪除或不存在,導致 LOCK TABLES 階段校驗失敗。
mysqldump --single-transaction -u root -p -h localhost dbname | gzip > /tmp/dbname_$(date +%F).sql.gz
--single-transaction:InnoDB 表可獲取一致性快照,無需 LOCK TABLES,繞過 DEFINER 校驗。CREATE USER 'yunuser'@'%' IDENTIFIED BY 'password'; GRANT SELECT ON *.* TO 'yunuser'@'%'; -- 按需授權 FLUSH PRIVILEGES;
sed -i "s/DEFINER=\`yunuser\`@\`%\`/DEFINER=\`root\`@\`localhost\`/g" dump.sql
或使用工具(如 mysqlpump、mysqldump --skip-definer 5.7.31+ 支持)重新導出。
--single-transaction,避免鎖表且繞過 DEFINER 問題。SELECT DEFINER FROM information_schema.VIEWS/ROUTINES/TRIGGERS 確認用戶存在。