mysql导入视图错误ERROR 1449

MYSQL导入时，如果存在视图，可能导致导入不成功，错误提示： ERROR 1449(HY000) at line xxx: The user specified as a definer (‘xxx’@’xxx’) does not exist

解决办法1：

sed '/\/*!50013/d' backup.sql > backup_without_50013.sql

解决办法2：

$contents = file_get_contents('backups/backup.sql');
$contents = preg_replace('@/*!50013 DEFINER.*?*/@' , '' , $contents);
file_put_contents('backups/backup.sql' , $contents);

[Import mysql dump files with view definer and sql security](http://www.binarytides.com/mysql-view-definer-and-sql-security/)

本条目发布于[2014年6月6日](https://c4ys.com/archives/234 "14:49")。属于[Database](Linux(https://c4ys.com/archives/category/linux)分类，被贴了 [mysql](https://c4ys.com/archives/tag/mysql) 标签。