backup error while doing mysql backup
 

Every time I do backup, I got this error message:

I have several mysql databases that I need to be included in backup. I can access them normally as root user through phpMyAdmin.

I am running IPS Manager Pro 4.3 on VPS.net server (Ubuntu 8.04 x64 LAMP).

Thanks a lot for your nice and useful software!

You need to write correct mysql root password in the ISPmanager Server configuration - Database servers menu

It's already done. I put "root" as user there and valid password. With this password I can login in phpMyAdmin as root user and work with DBs without problems.

Please check file my.cnf or .my.cnf in your home directory. There should be an alternative configuration which is used when mysql tries to do a dump

Thanks for advice. I found file .my.cnf, but not in /home directory, but in /root directory. I changed it to be:

[client]
user=root
pass=mypasshere

However, the error is still there. Should I copy this file to /home directory?

You do not need to add lines with password to my.cnf file, you need to remove it if this file contain incorrect data.

Login and password for mysql server must be inserted in the ISPmanager - Database servers menu

OK, I removed it from /root. DB pass is already in Database servers menu. Beside that:

Connection type: Local
Coding: Latin1
Path to socket file: /var/run/mysqld/mysqld.sock
Access: Allow to all