Page 1 of 1

Automatic backup finished only if exclude database

Posted: Sun Jan 31, 2016 11:03 am
by asixja
On which VPS and have several vebistes, and several bases under attack.
I do not have any databases related to "admin_default".
In phpMyAdmin can connect with the username "root" and the password. Then, I see all the databases.
Where must change something "admin_default" that backup took only users and databases that exist?

In backup.log a have this:
-- DB --
2016-01-31 05:17:33 admin_default (mysql)
Error: Connection to localhost failed

=============
EDIT:
I had changed the order of bases in "db.conf" and I see that connection is not possible for all databases, not only for this that I said "admin_default"

Re: Automatic backup finished only if exclude database

Posted: Tue Feb 02, 2016 11:56 am
by skurudo
Try to Rebuild DB

Image

May be table broken and you need to repair this table?

Re: Automatic backup finished only if exclude database

Posted: Tue Feb 02, 2016 6:42 pm
by asixja
@skurudo, thank you for your answer.
I fixed my problem.
The database "admin_default" don't exist.
When I excluded it, backup finished to end.

Now, I have another problem :).
Cron daily backup dont working job

Code: Select all

sudo /usr/local/vesta/bin/v-backup-users 
sudo /usr/local/vesta/bin/v-update-sys-queue backup 

Re: Automatic backup finished only if exclude database

Posted: Tue Feb 02, 2016 8:34 pm
by asixja
Working Cron backup :), sorry, my mistake.
I'm happy!
I love VestaCP.

Re: Automatic backup finished only if exclude database

Posted: Wed Feb 03, 2016 10:57 am
by skurudo
Good to know. asixja, thanks for update ;-)

Closed.