Backups failed

3 posts / 0 new
Topic locked
Last post
#1 Sat, 04/13/2013 - 03:44
icex

Backups failed

For all domains with MySQL databases the backup fails for this reason:

Dumping MySQL database freshit .. .. dump failed! Warning: Using a password on the command line interface can be insecure.

Server version: 5.6.5-m8 MySQL Community Server (GPL) - CentOS

The backup file is ok, it contains all databases but we receive a failure message every time by email.

Thu, 04/24/2014 - 13:35
maznos

It's too late to post, but I had the same issue yesterday and found out that it was because I saved root password in the file /root/.my.cnf

I had to delete it.

Mon, 04/28/2014 - 03:29
tomanglais

Its a warning in 5.6.

The official line is that you shouldn't call mysql with passwords on the command line and should use the credentials file.

Obviously Virtualmin does things in a certain way, the work around is to say ignore errors and continue and it works fine, it'll say failed but everything including databases is there.

Topic locked