Backup MySQL Database

[torvista]

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

[torvista]

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)

[jodean]

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?

[swguy]

Please post the debug log file from the /logs folder. It has been tested and should work.

[jodean]

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.

[torvista]

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.

[OldNGrey]

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

[lat9]

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.

[torvista]

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.

[swguy]

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