Support Center > Knowledgebase > DirectAdmin > MySQL / MariaDB > mysqldump: Got error: 1449: The user specified as a definer ('da_admin'@'%') does not exist when using LOCK TABLES
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
Also Read