MYSQL Backup addon error

[Lee Mason Design]

My apologies Dr Byte!!

I masked my real admin address by typing in 'admin' for the example of my error message, oh whoops it's lowercase ..etc..

Basically, assuming for a minute that I haven't actually done anything to the original code (I hadn't)

and the code looked exactly the same as the last user who asked the very same question (it did) ..

Then what I am pointing out is (just like that other user) I had to delete your FS_ADMIN in the FS_BACKUP definition in favour of a full filepath to my backup directory in order to get it to work on the site.

Yet on the other site (on the same hosting server, and both using same version of Zen Cart, installed on the same day) it worked fine with no tweaking neccessary!


I wanted to draw attention to the fact that even on the same host this contibution looks a bit hit and miss (thus far!).

I thought that perhaps a demonstrated 'filepath fix' be offered in the installation instructions with 'MySql Backup' ?

Other users may have the same problem and this would probably save them some time.

[pixelwrangler]

ZC current version. Backup button appears, directory permissions 777.

Backup attempt generates:

Warning: dir(DIR_FS_backups/) [function.dir]: failed to open dir: No such file or directory in /home/fasteners/www/www/catalog/myadmin/backup_mysql.php on line 402


The relevant parts of the configure.php file:

define('DIR_FS_ADMIN', '/home/myclient/www/www/catalog/myadmin/');

define('DIR_FS_BACKUP', DIR_FS_ . 'backups/');

Any ideas as to why the backup is failing?

[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.