After upgrading 2.4.6 backup database doesn't work

Software Support
1

Dear Sir,

I am getting the following error when i tried to backup the database. I was able to backup codes and files. The folders were given permission.

WARNING: An error may have occurred during the backup process. The most common cause is file permissions.

For your reference, what we did,

Added following line on config.inc.php page under section [cli]

dump = /usr/bin/mysqldump -h %s -u %s -p%s %s

  • replaced %s with hostname, username, password and dbname

We are getting following error message on this,

“WARNING: An error may have occurred during the backup process. The most common cause is file permissions.”

How do we fix it ?

Thanking you in advance

Latha

2

Hi @latha_ojs,

Does the binary /usr/bin/mysqldump exist on your server, and do you have permission to execute it?

Note that the plugin itself will take care of replacing the %x tokens with configuration from the journal. You don’t need to do this yourself.

Regards,
Alec Smecher
Public Knowledge Project Team

3

We have the same issue. the binary is in the spec’d directory. ls - l shows the root as owning the programs including mysqldump. How do we proceed from here? Thanks!