[SOLVED] Backups fails on mysql

[aximus]

The automatic backups are failing, and keeps trying to create a new backup, causing high server load. I see this in the log:

-- DB --
2017-04-17 00:22:17 admin_foo (mysql)
2017-04-17 00:22:18 admin_bar (mysql)
sh: 0: getcwd() failed: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
sh: 0: getcwd() failed: No such file or directory
exim: can't get the current working directory: No such file or directory
Error: dump admin_bar failed

(anonymised using 'foo' and 'bar')

I googled the problem and found some answers pointing to viewtopic.php?f=40&t=9694#p34401. But I don't understand how that is supposed to help.

Help is much appreciated.

[skurudo]

This is the environment variables which help with paths to executable files

[aximus]

Solved the problem:

The mysql backup failed for `admin_bar`. In order to fix it, I logged in to phpmyadmin and noticed something was wrong in the `admin_bar` database. After repairing all tables (and in my case, dropping one weird table), all was good.

[skurudo]

Nice catch, aximus
Thanks for your report.