Backup failed

[ODEKK]

Hey there. I have a VESTA panel giving the following error when trying to backup:

"An existing backup is already running. Please wait for that backup to finish."

These are the server stats:

Ubuntu 12.x
3GB ram
2 sites running

Any help on how to flush out whatever is hanging up this backup?

Kevin

[ODEKK]

I also keep getting a server email that says,

"Can't dump mysql database admin_moodle"

The site is working fine, though.

Kevin

[skid]

Hi Kevin,

here are the commands to flush the backup queue:

Code: Select all

rm /usr/local/vesta/data/queue/backup.pipe
touch /usr/local/vesta/data/queue/backup.pipe

Most probably one of the admin_moodle table is corrupted you can repair it using PMA or running following command as root

Code: Select all

mysqlcheck -r admin_moodle

[ODEKK]

Thanks for your reply. I was able to use the first commands you sent. Yet the second ones you sent returned the following:

admin_moodle.adodb_logsql
note : The storage engine for the table doesn't support repair
admin_moodle.mdl_assign
note : The storage engine for the table doesn't support repair
admin_moodle.mdl_assign_grades
note : The storage engine for the table doesn't support repair
admin_moodle.mdl_assign_plugin_config
note : The storage engine for the table doesn't support repair


These listings went on and on....quite a few entries differing only at the end of each string.

Any suggestions? Thanks again for your help.

Kevin Odekirk

[ODEKK]

Now when I click create backup, the system gives the expected notice that the backup is being created. but nothing happens. No additional backup is created.

Kevin

[ODEKK]

Anyone have any suggestions? I'm open to anything. I really appreciate all your help.

Thank you,

Kevin

[skid]

Can you dump this database using cli to check if it's not corrupted or something?

Code: Select all

mysqldump admin_moodle > /tmp/admin_moodle.sql

[kaavain]

Has the same situation.

Does it resolved in past two years?

[matolog]

I have similar problem.

Vesta created 3 backups of 3 websites. Then (cant remember exactly steps) I did:
- start manually backup
- remove 3 backups via MidnightCommander
- remove 1 website from vesta
- add directory exclusion to backup config
- remove 3 backups in vesta
- start manually backup
-- now I have no real backup on /home/backup/ , just temps till end of free space

I used for the moment "rm usr/local/vesta/data/queue/backup.pipe", but this is just for time, because I want backups to have automatically...

Any ideas how can i clear it everything and start auto-backuping without reinstalling whole system?

thanks for any hints