We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
backup failed
backup failed
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:
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!
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
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
Try to add in your /etc/mysql/my.cnf or /etc/my.cnf option
Restart mysql and check again.
Code: Select all
skip-external-locking