Vesta Control Panel - Forum

Posted: **Wed Mar 15, 2017 12:37 pm**

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

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

and these errors I found in usr/local/vesta/log/error.log

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]

In nginx domain error log I get something like this very often

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"

and also I wanted to mention this warning I am getting in WordPress which is related to the database

Code: Select all

PHP Warning: Error while sending QUERY packet. PID=18213 in /wp-includes/wp-db.php on line 1877

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

Posted: **Thu Mar 16, 2017 1:17 pm**

Code: Select all

17	E_DB	Database server is not responding

In your mysql config increase those:

Code: Select all

max_allowed_packet
wait_timeout

About repair db, use this command from console:

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

Posted: **Fri Mar 17, 2017 9:07 am**

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

Code: Select all

Error: dump marketon_wp000 failed

I have set these values already
max_allowed_packet 1024M
wait_timeout I think 60

Please advise.

Thank you

Posted: **Thu Mar 23, 2017 10:24 am**

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

Posted: **Wed Mar 29, 2017 3:16 pm**

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

Vesta Control Panel - Forum

Automatic back-up stopped working for a single user only

Automatic back-up stopped working for a single user only

Re: Automatic back-up stopped working for a single user only

Re: Automatic back-up stopped working for a single user only

Re: Automatic back-up stopped working for a single user only

Re: Automatic back-up stopped working for a single user only