MYSQL Backup addon error

[DrByte]

Well after nosing around I learned that, despite the Zen instruction to turn on safe mode, this backup utility will not function if it is on. All the buttons etc. appear but it won't work. I either have to leave safe mode off or remember to turn it off when I want to do a backup.

I'm not sure what "Zen instruction to turn on safe mode" you're referring to.
Zen Cart has *always* recommended against the use of safe mode, as there are many far more efficient and effective ways to secure a server other than the overly restrictive safe mode in PHP.

So, yes, turn off safe mode. The warning message in the backup_mysql tool specifically says that it typically won't work if safe mode is turned on.

[auick]

This addon has been work great on our site almost one years, but recently after i add 10,000 more products, and database size increases from 10MB to 135MB(.sql format), backup become not work well, the download result is 0 Byte.

I am wondering if this model has any restrict like size of database or something else? Hopefully somebody can give some tips how can i get backup success again. Because it bring so much convenience to backup.

Appreciate very much for your time!

[DrByte]

I have no idea why yours is having problems. I regularly use it to backup a 2GB database with no problems (takes about 2 minutes, during which the server appears frozen, but otherwise works fine).

[Lee Mason Design]

Warning: dir(DIR_FS_admin/) [function.dir]: failed to open dir: No such file or directory in /home5/fivadayd/public_html/admin/backup_mysql.php on line 402

Fatal error: Call to a member function read() on a non-object in /home5/fivadayd/public_html/admin/backup_mysql.php on line 404

--------------------------------------------------------------------------------------------------------------------------

I have setup 2 sites this week, both on same server, both in exactly the same way. I have looked at your previous fixes and compared the admin/includes/config.php files of bothe websites and both are set up exatly the same. I do not understand why one is working fine and one is not working at all?

The current solution on this topic is a little bit vague, as I would only have to put a / in front of my path if I swap the DIR_FS_admin for a complete file path wouldn't I?
But why would I even have to do this if it works on my other website automatically without changing anything??

Regards,

Lee

[DrByte]

Warning: dir(DIR_FS_admin/): failed to open dir: No such file or directory ...

I don't understand why it's saying "DIR_FS_admin" instead of the uppercase "DIR_FS_ADMIN".

Furthermore, the code in the backup_mysql.php file refers to DIR_FS_BACKUP, and not DIR_FS_ADMIN at all! So, it seems whatever you've done to define('DIR_FS_BACKUP',....) is clearly pointing to the wrong thing.

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