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.
Automatic back-up stopped working for a single user only
Automatic back-up stopped working for a single user only
Hi,
I have recently noticed that one of my user's automatic back-up stopped working. I can see that it has something to do with the mySQL database marketon_wp000 I use on the production wordpress website. I get these errors below in the usr/local/vesta/log/backup.log
and these errors I found in usr/local/vesta/log/error.log
In nginx domain error log I get something like this very often
and also I wanted to mention this warning I am getting in WordPress which is related to the database
Can anyone help me to fix my issue with the auto backup and mySQL database, please?
I have tried to repair the database in phpMyAdmin and also clear the back up queue by following instructions I found in other VestaCP threads related to Auto backup issue. " No success" :(
Thank you in advance
Almost forgot to mention my current setup
PHP&Ubuntu version: 7.0.15-0ubuntu0.16.04.4 64bit
MySQL Version:5.7.16
Nginx:1.11.10
I have recently noticed that one of my user's automatic back-up stopped working. I can see that it has something to do with the mySQL database marketon_wp000 I use on the production wordpress website. I get these errors below in the usr/local/vesta/log/backup.log
Code: Select all
-- DB --
2017-03-14 05:47:12 marketon_dev (mysql)
2017-03-14 05:47:13 marketon_dev000 (mysql)
2017-03-14 05:47:21 marketon_dev001 (mysql)
2017-03-14 05:47:23 marketon_wp000 (mysql)
Error: dump marketon_wp000 failed
Code: Select all
2017-03-10 09:35:53 v-list-mail-accounts 'admin' 'marketonchart.com' 'json' [Error 3]
2017-03-11 05:32:50 v-backup-user 'marketon' [Error 17]
2017-03-12 05:33:06 v-backup-user 'marketon' [Error 17]
2017-03-13 05:32:43 v-backup-user 'marketon' [Error 17]
2017-03-14 05:47:32 v-backup-user 'marketon' [Error 17]
Code: Select all
2017/03/15 13:00:31 [crit] 25644#25644: *2142 open() "/home/marketon/web/marketonchart.com/public_html/" failed (13: Permission denied), client: 52.71.110.246, server: marketonchart.com, request: "GET / HTTP/1.1", host: "marketonchart.com"
Code: Select all
PHP Warning: Error while sending QUERY packet. PID=18213 in /wp-includes/wp-db.php on line 1877
I have tried to repair the database in phpMyAdmin and also clear the back up queue by following instructions I found in other VestaCP threads related to Auto backup issue. " No success" :(
Thank you in advance
Almost forgot to mention my current setup
PHP&Ubuntu version: 7.0.15-0ubuntu0.16.04.4 64bit
MySQL Version:5.7.16
Nginx:1.11.10
Re: Automatic back-up stopped working for a single user only
Code: Select all
17 E_DB Database server is not responding
Code: Select all
max_allowed_packet
wait_timeout
Code: Select all
mysqlcheck --no-defaults -u root -p --all-databases
mysqlcheck --no-defaults -u root -p --all-databases -o
mysqlcheck --no-defaults -u root -p --all-databases --auto-repair
mysqlcheck --no-defaults -u root -p --all-databases --analyze
Re: Automatic back-up stopped working for a single user only
Hi and thanks a lot for quick reply,
however, I have done all that but the automatic back up didn't catch up. Should I do anything else ?
I am still getting
I have set these values already
max_allowed_packet 1024M
wait_timeout I think 60
Please advise.
Thank you
however, I have done all that but the automatic back up didn't catch up. Should I do anything else ?
I am still getting
Code: Select all
Error: dump marketon_wp000 failed
max_allowed_packet 1024M
wait_timeout I think 60
Please advise.
Thank you
Re: Automatic back-up stopped working for a single user only
Hi,
I need your help to fix the issue with auto back up as It's been almost 4 months since my website was backed up. I use snapshots when make changes to my server or websites but this is just a temp solution.
Do you want me to provide you with the results of the mysql checks and repair ?
Please let me know or advise me what else to try to fix my database in order to make the automated back up working again for that particular website.
Thank you in advance
I need your help to fix the issue with auto back up as It's been almost 4 months since my website was backed up. I use snapshots when make changes to my server or websites but this is just a temp solution.
Do you want me to provide you with the results of the mysql checks and repair ?
Please let me know or advise me what else to try to fix my database in order to make the automated back up working again for that particular website.
Thank you in advance
Re: Automatic back-up stopped working for a single user only
Hi,
can you please help here as I am not the MySQL database expert. What else I can do in order to allocate and fix my database issue which is not letting the auto back up run through :(
I appreciate any kind of hint or suggestion
Thanks
can you please help here as I am not the MySQL database expert. What else I can do in order to allocate and fix my database issue which is not letting the auto back up run through :(
I appreciate any kind of hint or suggestion
Thanks