Page 26 of 27 FirstFirst ... 1624252627 LastLast
Results 251 to 260 of 265
  1. #251
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,408
    Plugin Contributions
    88

    Default Re: Backup MySQL Database

    Quote Originally Posted by g2ktcf View Post
    I am testing a site very similar to lat9 https://www.example.com/test. I am getting this error.

    0 => mysqldump: Got error: 1045: "Access denied for user '************User'@'localhost' (using password: YES)" when trying to connect
    Does your site's database password also include any "special" characters?

  2. #252
    Join Date
    Feb 2011
    Location
    Lumberton, TX
    Posts
    508
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I saw your issues with special characters (there are three). I have plans to change that and see if that works.

  3. #253
    Join Date
    Feb 2011
    Location
    Lumberton, TX
    Posts
    508
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    After removing all special characters, this works just fine.

  4. #254
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    9

    Default Re: Backup MySQL Database

    Quote Originally Posted by lat9 View Post
    Does your site's database password also include any "special" characters?
    speaking of special characters.....

    if your admin directory has any special characters, it seems that the following change is necessary (for backing up... around line 133):

    PHP Code:
    //from
    $dump_params .= ' "--result-file=' DIR_FS_BACKUP $backup_file '"';
    //to
    $dump_params .= ' "--result-file=' escapeshellcmd(DIR_FS_BACKUP) . $backup_file '"'
    it may be worth wild to change all instances of DIR_FS_BACKUP to $backup_directory and define said var at the beginning of the script as such:

    PHP Code:
    $backup_directory escapeshellcmd(DIR_FS_BACKUP); 
    but alas, i do not have the time or inclination at this moment for further testing.
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

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

    Default Re: Backup MySQL Database

    Since I have modified this to death over the years, I've set up a new repository based on this plugins history to be able to add in changes at some point.

    So please add this link to the plugin page for reporting issues:

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

  6. #256
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,572
    Plugin Contributions
    30

    Default Re: Backup MySQL Database

    When doing a backup->Download without storing on server, I note that
    - a dumpfile is created, ok
    - a download window opens, ok
    - the download occurs, ok
    - another dumpfile is created, NOT ok.

    After the header-exit, it seems to be re-running the same page using action backupnow, but despite my efforts I can't stop it.
    Consequently every time I take a backup snapshot from the hosting for local use, it leaves behind 300Mb of debris which I need to delete manually.

    (In my modified version of this plugin, the original dumpfile is unlinked after download, but still, a new one is created as per the plugin version)
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  7. #257
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,408
    Plugin Contributions
    88

    Default Re: Backup MySQL Database

    Quote Originally Posted by torvista View Post
    Since I have modified this to death over the years, I've set up a new repository based on this plugins history to be able to add in changes at some point.

    So please add this link to the plugin page for reporting issues:

    https://github.com/torvista/Zen_Cart-Backup_MYSQL_Plugin
    All finished.

  8. #258
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,572
    Plugin Contributions
    30

    Default Re: Backup MySQL Database

    Damn...now I suppose I'll have to do something with it!
    Given the absence of comments here and there, looks like it is rarely used...I use it constantly.
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

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

    Default Re: Backup MySQL Database

    Thanks folks.

    Also note that since some hosters are allergic to this script, so you may have to resort to another option for building a backup.
    You can use cPanel backup or backup via phpMyAdmin as noted in the documentation.

    https://docs.zen-cart.com/user/runni...-your-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.

  10. #260
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,572
    Plugin Contributions
    30

    Default Re: Backup MySQL Database

    I suppose the problem is in the use of exec.

    I'd also point out my use case is I don't use this for production backups, that's a separate automated process.
    I use this as a dev tool, to get a copy of production db for use locally, usually to test imports first, or to test install scripts/do repeated restores: much easier to in the admin than elsewhere. Invaluable in that respect.
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

 

 
Page 26 of 27 FirstFirst ... 1624252627 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