Backup MySQL Database

It's likely that the path to the mysqldump binary may be causing it, and instead the path should perhaps be left out.

mysqldump

instead of

/usr/bin/mysqldump

Either that, or the way the command is being sent isn't properly separating the command from its parameters...

DrByte:

It's likely that the path to the mysqldump binary may be causing it, and instead the path should perhaps be left out.

mysqldump

instead of

/usr/bin/mysqldump

Either that, or the way the command is being sent isn't properly separating the command from its parameters...

Hmmm.. that doesn't do it either. I have switched to a zencart certified host from dreamhost, and have the same problem on the new host.

Just a note that may apply. Previously after installing the BU plugin on v1.26, and later on 1.30, when I first ran the tool I received the same errors reported below (unable to find binary and backup failed). However the backup still worked (successfully backed up my database, both to the server and downloaded to my client). I successfully tested restoring my db's with the backups.

Later I had my domain account moved to an upgraded server and then I did a fresh install of 1.3.0.1. The plugin installed on 1.3.0.1 without those errors. And works fine.

Apologies if you've already responded to the questions below, but in case not...

What are permissions on your /admin/backups folder?

Do you see the same errors when backing up to the server versus downloading backup (choosing "Download without storing on server")? I don't normally backup to my client using this tool but useful for testing.

Do you see these same errors if GZIP is enabled or not (in Zen Cart admin - Configuration > GZIP)? (shouldn't apply but you never know).

Woody

Just downloaded and installed v 1.2.0.10a onto Zencart v 1.3.0.1

I had no problems installing - I've used previous versions on versions 1.2x of Zencart with no problems whatsoever.

One small bug I have found with the new version is that if I backup to the server and click the 'No compression' radio button I get a .gzip file rather than an uncompressed file. If, however, I tick the 'Download without storing on the server' box I get an uncompressed file as expected.

Anyone else experienced this problem?

Great tool b.t.w. I never install Zencart without it.

Regards,

Alan

Yep same for me too!

I've gone back to an earlier version (around sept 05) and it works as it should.

While a lot of other stuff was probably fixed, this small quirk was introduced.

Woodymon:

Just a note that may apply. Previously after installing the BU plugin on v1.26, and later on 1.30, when I first ran the tool I received the same errors reported below (unable to find binary and backup failed). However the backup still worked (successfully backed up my database, both to the server and downloaded to my client). I successfully tested restoring my db's with the backups.

Later I had my domain account moved to an upgraded server and then I did a fresh install of 1.3.0.1. The plugin installed on 1.3.0.1 without those errors. And works fine.

Apologies if you've already responded to the questions below, but in case not...

What are permissions on your /admin/backups folder?

Do you see the same errors when backing up to the server versus downloading backup (choosing "Download without storing on server")? I don't normally backup to my client using this tool but useful for testing.

Do you see these same errors if GZIP is enabled or not (in Zen Cart admin - Configuration > GZIP)? (shouldn't apply but you never know).

Woody

Permissions are 777 on admin/backups, and I get the same error no matter which combination of settings I use. This is hosted on camelot-hosting, so there shouldn't be anything weird with their setup.

I tried downloading a fresh version of the mod and reinstalling and everything works! Not sure if there was some weirdness when I originally installed it on my old host, or if I messed it up somehow. Thanks for all the suggestions.

duncanad:

Just downloaded and installed v 1.2.0.10a onto Zencart v 1.3.0.1

One small bug I have found with the new version is that if I backup to the server and click the 'No compression' radio button I get a .gzip file rather than an uncompressed file. If, however, I tick the 'Download without storing on the server' box I get an uncompressed file as expected.

Anyone else experienced this problem?
Yes. I am running Zen Cart 1.3.0.1 with backup_mysql_admin_plugin-1.2.1.0 (not A).

I cannot disable the compression radio button, no matter if backing up to server or if download to remote client..

Workaround: When I want to back up with compression off I just turn it off in Configuration > GZip Compression. Then I back up.

But I have found no reason to disable GZip. Instead of a 20.5MB DB I get a 2MB DB. ;)

Woody

i just installed this contrib... i went to tools and database backup but all it has there is a warning about not using SSL and a restore button... am i missing something??

GazLuvsStace:

i just installed this contrib... i went to tools and database backup but all it has there is a warning about not using SSL and a restore button... am i missing something??
Reading some of the posts below and the caveats in the readme, did you observe any security restrictions in effect which may be contributing to your issues?

Woody

Woodymon:

Reading some of the posts below and the caveats in the readme, did you observe any security restrictions in effect which may be contributing to your issues?

Woody
yep... there was only 1 i was unsure of which is

"open_basedir /home/httpd/vhosts/domainname/httpdocs:/tmp"

having no idea what that is... or no knowledge of server side stuff??

GazLuvsStace:

i just installed this contrib... i went to tools and database backup but all it has there is a warning about not using SSL and a restore button... am i missing something??

"open_basedir /home/httpd/vhosts/domainname/httpdocs:/tmp"
having no idea what that is... or no knowledge of server side stuff??

You don't see the Restore and Backup buttons? The security settings should not have impact on rendering of the admin page.

Can you provide a screenshot?

Which version of the Backup mod is installed?
Latest is 1.2.10a (last updated by DrByte on 01-10-06)

Recommend re-uploading the four files:
/admin/backup_mysql.php
/admin/includes/boxes/extra_boxes/backup_mysql_tools_dhtml.php
/admin/includes/extra_datafiles/backup_mysql.php
/admin/includes/languages/english/backup_mysql.php

Woody

Woodymon:

You don't see the Restore and Backup buttons? The security settings should not have impact on rendering of the admin page.

Can you provide a screenshot?

Which version of the Backup mod is installed?
Latest is 1.2.10a (last updated by DrByte on 01-10-06)

Woody
Im using that version... hmm this contrib is for the latest release of zencart isnt it??? pretty sure i read that it was :S.
anyways here is a SS

REMOVED PER REQUEST

Sorry to take so long to respond to replies to my post. Although I'm subscribed to this thread I don't seem to be receiving email notifications of new posts.

Anyway thanks for the responses.

Woodymon:

Workaround: When I want to back up with compression off I just turn it off in Configuration > GZip Compression. Then I back up.

When I checked my configuration GZip compression was set to 'Off' so this setting does not appear to affect how the backup operates.

Woodymon:

But I have found no reason to disable GZip. Instead of a 20.5MB DB I get a 2MB DB. ;)
Woody

I quite agree. However it depends on how critical your data is - and how paranoid you are! By compresing the data there is a slight increase in the risk of corrupting the data. Larger backup files might be preferable to lost data. Anyway the engineer in me thinks if you are given the option then you should have that option.

Not a big issue - and still an indespensible contribution.

Thanks,

Alan

I'm running backup_mysql_plugin_1.2.10 dated Jan 10, 2006, on Zen Cart v1.3.0.1

The "No Compression (Pure SQL)" radio button in the BU mod dialog is defectively sticky, after the first time I selected I have never been able to unselect. I've deemed it a bug and just worked around it by disabling and enabling Gzip from the admin config menu.

I was the same way, not compressing the DB at first. But after many imports and exports I am now just fine with compressing.

Woody

DrByte,
I have a renamed admin folder - When I installed it would seem the MySQL plugin couldnt find my backups dir anymore. (It exists, just under my new admin location.) I searched the file, and couldnt find any hard references. I also looked in config.php in admin/includes.

My problem was not only should
define('DIR_WS_ADMIN', '/store/xxx/');
define('DIR_WS_HTTPS_ADMIN', '/store/xxx/');

be changed, but ALSO:
define('DIR_FS_ADMIN', '/var/users/xyz/abc/htdocs/store/xxx/');

I dont know if this info might be useful to stick in the docs you have for it...

Fantastic work, thanks for the plugin!!!

Thanks very much for posting the solution to your backups issue with a renamed /admin ... this will help others who also are following the suggestion to rename the /admin for security purposes ... :smile:

theodin:

I also looked in config.php in admin/includes.

My problem was not only should
define('DIR_WS_ADMIN', '/store/xxx/');
define('DIR_WS_HTTPS_ADMIN', '/store/xxx/');

be changed, but ALSO:
define('DIR_FS_ADMIN', '/var/users/xyz/abc/htdocs/store/xxx/');

The instructions regards to above, plus many more important instructions, are located in /docs/important_site_security_recommendations.html

i get the following message when trying to backup:

0 => 'c:/apache2triad/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,

does this mean the server is running "in strict safe_mode,
or with open.basedir restrictions in effect, or with restrictions against
using "exec()" commands. "

I have been using this mod successfully for about two months. But today I went to admin to make a backup and when i click admin/tools/backup mysql I get a blank page. I've tried this in both IE and Firefox with the same result. Any ideas whats going on and how to fix?

Jason