Backup process does not backup databases - Leaves sql empty

[factor]

You have a bad my.cnf in your find list.

Common "bad" my.cnf files are:

• /etc/mysql/my.cnf

You shouldn't have this file. You shouldn't even have a /etc/mysql directory, as it will conflict with your /etc/my.cnf.

• /root/.my.cnf

This should not exist as our call to mysqldump will find it, which breaks our calls to mysqldump if it contains a user/password.

You need to delete this file.

rm -f /root/.my.cnf

once you do this try backing up again.

 

[llamprec]

You have a bad my.cnf in your find list.

Common "bad" my.cnf files are:

• /etc/mysql/my.cnf

You shouldn't have this file. You shouldn't even have a /etc/mysql directory, as it will conflict with your /etc/my.cnf.

• /root/.my.cnf

This should not exist as our call to mysqldump will find it, which breaks our calls to mysqldump if it contains a user/password.

You need to delete this file.

rm -f /root/.my.cnf

once you do this try backing up again.

After deleting the file /root/.my.cnf I then ran a successful backup. This has resolved the issue.

Thanks again for your great help and advice.
Lawrence

 

[Richard G]

After deleting the file /root/.my.cnf I then ran a successful backup. This has resolved the issue.

Which I already asked to do in post #5.

 

[llamprec]

Which I already asked to do in post #5.

Sorry mate, I completely missed your suggestion. Very impressed and happy with both of your patience.

Thanks again for the dilligent follow-up.
Lawrence