Page 1 of 2 12 LastLast
Results 1 to 10 of 327

Hybrid View

  1. #1
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,831
    Plugin Contributions
    31

    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: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

  2. #2
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,831
    Plugin Contributions
    31

    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: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

  3. #3
    Join Date
    May 2011
    Location
    Tennessee
    Posts
    510
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I just tried the backup mysql on my new 2.0.1 upgrade and it just gives a blink to the admin page and returns to the admin page. Has anyone successfully install it?

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,522
    Plugin Contributions
    127

    Default Re: Backup MySQL Database

    Please post the debug log file from the /logs folder. It has been tested and should work.
    That Software Guy. My Store: Zen Cart Support
    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.

  5. #5
    Join Date
    May 2011
    Location
    Tennessee
    Posts
    510
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by swguy View Post
    Please post the debug log file from the /logs folder. It has been tested and should work.
    Thanks for your reply. The same symptom existed in another plugin. So I recovered from a backup before the backup plugin was added and installed the backup plugin again and it worked. I must has done something wrong. It works now.

  6. #6
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,831
    Plugin Contributions
    31

    Default Re: Backup MySQL Database

    I've long been making changes to this plugin and have finally incorporated them in GitHub, branch dev:

    https://github.com/torvista/Zen_Cart...lugin/tree/dev

    including:
    • converted to an encapsulated plugin
    • auto-finds the mysql executables (stores result in db so does not run auto-find every time).
    • allow a suffix to be added to the backup filename
    • allow gzip and zip compression for backup and restore


    So would appreciate some testing and feedback in the issues.

    Caveat Emptor, as always.
    Steve
    github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

  7. #7
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    407
    Plugin Contributions
    6

    Default Re: Backup MySQL Database

    I only recently stumbled onto this plugin by accident.
    Very nice work!


    Tested on zc 2.1.0 with PHP 8.4.1 MariaDB MySQL 11.6.2
    with export and restore
    OldNGrey
    ZC222 PHP 8.4.16
    MySQL 11.8.5-MariaDB

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,913
    Plugin Contributions
    96

    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.

  9. #9
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,831
    Plugin Contributions
    31

    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: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

  10. #10
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,522
    Plugin Contributions
    127

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

 

 
Page 1 of 2 12 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

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