Page 1 of 1

backup failed

Posted: Thu Jan 08, 2015 11:09 am
by 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!

Re: backup failed

Posted: Sun Mar 15, 2015 10:35 pm
by 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.