Page 4 of 21 FirstFirst ... 2345614 ... LastLast
Results 31 to 40 of 207
  1. #31
    Join Date
    Nov 2005
    Posts
    21
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by 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??

  2. #32
    Join Date
    Sep 2004
    Posts
    2,420
    Plugin Contributions
    2

    Default Re: Backup MySQL Database

    Quote Originally Posted by 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

  3. #33
    Join Date
    Nov 2005
    Posts
    21
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by 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
    Last edited by Ajeh; 10 Jun 2006 at 04:58 AM.

  4. #34
    Join Date
    Nov 2004
    Location
    Glasgow, Scotland
    Posts
    251
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    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.

    Quote Originally Posted by 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.

    Quote Originally Posted by 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

  5. #35
    Join Date
    Sep 2004
    Posts
    2,420
    Plugin Contributions
    2

    Default Re: Backup MySQL Database

    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

  6. #36
    Join Date
    Sep 2005
    Posts
    26
    Plugin Contributions
    1

    Default Re: Backup MySQL Database

    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!!!
    Last edited by theodin; 3 Jul 2006 at 01:37 AM. Reason: correction

  7. #37
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,474
    Plugin Contributions
    6

    Default Re: Backup MySQL Database

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #38
    Join Date
    Sep 2004
    Posts
    2,420
    Plugin Contributions
    2

    Default Re: Backup MySQL Database

    Quote Originally Posted by 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
    Last edited by Woodymon; 3 Jul 2006 at 08:39 PM.

  9. #39
    Join Date
    Feb 2006
    Posts
    116
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

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

  10. #40

    Default Re: Backup MySQL Database

    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

 

 
Page 4 of 21 FirstFirst ... 2345614 ... LastLast

Similar Threads

  1. Backup MySQL Database vs using cPanel backup option?
    By IronMan101 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 30 Jul 2007, 08:46 AM
  2. Database Backup Manager - MySQL
    By sicness in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 7 Aug 2006, 09:42 PM
  3. Backup MySQL Database failure
    By JFD in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 3 Jun 2006, 06:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR