Backup MySQL Database

[GazLuvsStace]

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??

[Woodymon]

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

[GazLuvsStace]

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

[duncanad]

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.

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.

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

[Woodymon]

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

[theodin]

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!!!

[Ajeh]

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

[Woodymon]

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

[tekram]

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

[brimsjewelry]

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