Add to Favourites Add to Favourites    Print this Article Print this Article

mysqldump: Got error: 1449: The user specified as a definer ('da_admin'@'%') does not exist when using LOCK TABLES

If you get a backup error similar to:

Error while backing up database user_dbname
mysqldump error output: mysqldump: Got error: 1449: The user specified as a definer ('da_admin'@'%') does not exist when using LOCK TABLES

then add the following to your directadmin.conf and restart DA:

extra_mysqldump_options=--single-transaction



Was this answer helpful?

Also Read