Mysqldump executed by Virtualmin 4.16.gpl (database backup, virtual server backup, GUI or command line) is failing routinely for me, although I can manage databases from Virtualmin. I have read all threads I can find on this.
I have set the root password in /etc/webmin/mysql/config and checked that I can dump the databases using 'mysqldump' from command line (outside Virtualmin) with the same root password. I have checked the path to /usr/bin/mysqldump: anyway it was working previously.
The most frustrating part is that there is no error message apart from 'Database backup failed : mysqldump failed :
Warning: Using a password on the command line interface can be insecure.'
can you help?
(config file follows)
date_subs=0
max_text=1000
perpage=25
stop_cmd=/etc/init.d/mysql stop >/dev/null 2>&1
mysqldump=/usr/bin/mysqldump
nodbi=0
mysql_libs=/usr/local/mysql/lib
max_dbs=50
start_cmd=/etc/init.d/mysql start >/dev/null 2>&1 &
pass=[redacted]
mysql_data=/var/lib/mysql
mysqlimport=/usr/bin/mysqlimport
access=*: *
webmin_subs=0
style=1
my_cnf=/etc/mysql/my.cnf
login=root
mysqlshow=/usr/bin/mysqlshow
mysql=/usr/bin/mysql
nopwd=0
add_mode=1
passwd_mode=0
blob_mode=0
mysqladmin=/usr/bin/mysqladmin
Comments
Submitted by andreychek on Sat, 05/02/2015 - 11:39 Comment #1
Howdy -- is there a .my.cnf file located in the /root folder, or in the homedir of the domain that's failing?
If so, that could be causing the problem you're seeing. You may want to try renaming that file, and seeing if the backup works properly at that point.
Submitted by John_B on Sat, 05/02/2015 - 11:48 Comment #2
That was it! There was a .my.cnf in root. Deleting it fixed the issue. I had already checked virtual servers for this. No idea how it got there.. thanks.