backup failed

[arnada21]

Hi,

I've a little bit o problems with one of my users. First of all the automatic backups does not work for this user. I tried to create a backup manually by clicking on "Create backup.." in the administration of VestaCP.

Now it's looping and I get alot of error messages to my inbox.

I've tried to restart the cron service without any success.

I recive the following error:

Code: Select all

Can't dump database table_db
mysqldump: Got error: 1449: The user specified as a definer ('user'@'localhost') does not exist when using LOCK TABLES

The table_db exists but the user does not exist, it's called user_us.

My question is, how do I cancel this loop and how do I change so the correct mysql user is used when creating backups?

*Side note, this only affects 1 of 10 users.

Thank you!

[skurudo]

Try to add in your /etc/mysql/my.cnf or /etc/my.cnf option

Code: Select all

skip-external-locking

Restart mysql and check again.