MYSQL Backup addon error

[DrByte]

Um ... use DIR_FS_ADMIN instead of just DIR_FS_

[pfabrick]

We've used this tool on multiple Zen Carts in the past and now one of them has started throwing an error when running the tool:

Result code: 2
0 => mysqldump: Got error: 1045: Access denied for user 'username'@'localhost' (using password: YES) when trying to connect
Failure: The database has NOT been saved.

Where username is our user name for the database. It seems rather odd that we're logged into the admin and then the mod is unable to use the same user info to run the backup. We're using ver 1.3.5 on this store.

Thanks for your help.

[DrByte]

If your database is actually hosted on a separate server (ie: DB_SERVER isn't 'localhost') then you're going to encounter that error, and will have to use phpMyAdmin to do the database backups instead.

If the problem "just started" but was working "before", you'll need to work with your hosting company to figure out what the "something" was that changed "before" it broke.

[pfabrick]

Thank you for your update. We actually have a dedicated server which is hosting this Zen Cart and the data base resides on this server as well. We have other Zen Carts on this server which are using this mod successfully, we just can't get this one to work.

As we can back up via phpMyAdmin, it's just nicer to use this mod in the admin.

[linnx]

My Backup button disappeared. This was a great util. Any idea why the button would disappear? The restore button is still there.

Thanks

[DrByte]

If the backup folder isn't writable, the button won't be shown.

[linnx]

It is writable. chmod 777 on it. And I double checked.

Thanks

[DrByte]

Okay, then either your server has PHP Safe Mode enabled, or the PHP exec() command has been disabled by the server administrator, or the backup directory specified in your admin configure.php file doesn't match the directory you think it's supposed to be using and therefore it sees that the specified directory doesn't exist.
Or the backup button image is corrupt and not displaying, and needs to be re-uploaded.