Page 18 of 27 FirstFirst ... 81617181920 ... LastLast
Results 171 to 180 of 265
  1. #171
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: Backup MySQL Database

    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  2. #172
    Join Date
    Jan 2007
    Posts
    1,484
    Plugin Contributions
    10

    Default Re: Backup MySQL Database

    Quote Originally Posted by torvista View Post
    Been using this for a while now, back up my site daily on a schedule, works flawlessly!

    Zen Cart and it's community are the best!!

  3. #173
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,621
    Plugin Contributions
    123

    Default Re: Backup MySQL Database

    Re: Backup MySQL Database Result code: 2 mysqldump Error 1045

    Quote Originally Posted by DrByte View Post
    Could be that your database password (in DB_PASSWORD) contains a special character that's not translating well when the backup drops out to the command-line and passes the password parameter to do the database export. Anything in there like a $ or # or back-tick or quote/apostrophe or * or & might be problematic, depending on your server operating system.
    This issue has been fixed in the latest version of Backup MySQL Database.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  4. #174
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Backup MySQL Database

    Zen Cart 1.55e, newest version available v5d of the plugin fails backup. It goes through the motions with any selected option or combination and a 58 byte properly named and saved file is created or downloaded depending on the selections. The files are all empty.

    On page reload the 1045 error posts in the admin header.

    Works less now on 1.55e than it did before the update also my previous posts #169 #168 have not been corrected.

    Poses the question what does this actually work on and has it been properly tested?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  5. #175
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: Backup MySQL Database

    has it been properly tested?
    Couldn't say, I did a lot of changes to that a long time ago. As usual I got carried away and made so many changes I never got round to uploading it.
    Works for me, on my Github. Comments welcome.
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  6. #176
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,621
    Plugin Contributions
    123

    Default Re: Backup MySQL Database

    @twitchtoo Can you post some information on your environment? (OS, PHP version, MySQL version, etc.) I will check.
    Are you saying 1.5c did work and 1.5d does not work?
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  7. #177
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Backup MySQL Database

    Quote Originally Posted by swguy View Post
    @twitchtoo Can you post some information on your environment? (OS, PHP version, MySQL version, etc.) I will check.
    Are you saying 1.5c did work and 1.5d does not work?
    Client one:
    Zen Cart 1.55e
    Linux 2.6
    Php 5.6
    MySQL 5.5
    Backup MySQL Database version 1.5c - works in one button position only - referred to in previous post #168-169


    Client two:
    Zen Cart 1.55f
    Linux 2.6
    Php 7.1
    MySQL 5.6
    Backup MySQL Database version 1.5c - works in one button position only - referred to in previous post #168-169


    Client one and two update to Backup MySQL Database version 1.5d
    - posts only 58 byte file backups
    Last edited by twitchtoo; 10 Nov 2018 at 07:11 PM.
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  8. #178
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,621
    Plugin Contributions
    123

    Default Re: Backup MySQL Database

    Then I guess I'm stumped. You can see that the differences between 5c (left) and 5d (right) are small.

    Code:
    125c125
    <         $dump_params .= ' "--password=' . DB_SERVER_PASSWORD . '"';
    ---
    >         $dump_params .= ' "--password=' . escapeshellcmd(DB_SERVER_PASSWORD) . '"';
    258c258
    <         $load_params .= ((DB_SERVER_PASSWORD =='') ? '' : ' "--password=' . DB_SERVER_PASSWORD . '"');
    ---
    >         $load_params .= ((DB_SERVER_PASSWORD =='') ? '' : ' "--password=' . escapeshellcmd(DB_SERVER_PASSWORD) . '"');
    Can you do some testing with escapeshellcmd on your system and check the results? This works fine for me in similar environments.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  9. #179
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,621
    Plugin Contributions
    123

    Default Re: Backup MySQL Database

    Maybe try changing it to escapeshellarg() but remove the single quotes around the argument.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  10. #180
    Join Date
    Aug 2010
    Location
    US
    Posts
    14
    Plugin Contributions
    1

    Default Re: Backup MySQL Database

    Has anyone had any luck using this with the new release, 1.5.6? Just got it installed but it is not showing up under the Tools drop down.
    T. Patterson
    B&T Sales

    Zen-Cart Version 1.5.6

 

 
Page 18 of 27 FirstFirst ... 81617181920 ... 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