Backup MySQL Database

[swguy]

Seeing logs under PHP8.1:

--> PHP Warning: Undefined array key 1 in /home/bmicpanel/public_html/client/admin/backup_mysql.php on line 157.

where that line is

if (zen_not_null($resultcodes)) list($strA, $strB) = preg_split ('/[|]/', $resultcodes);

[torvista]

In my version I find I modified it for that same reason,
from
list($strA, $strB) = preg_split ('/[|]/', $resultcodes);
to
[$strA, $strB] = array_pad(explode('|', $resultcodes, 2), 2, null);

[swguy]

OK, but that change didn't make it to Github.

https://github.com/torvista/Zen_Cart...mysql.php#L155

looks just like what I posted.

[torvista]

Hmm, no, there's so many changes in my personal version, it's difficult to push things piecemeal logically...haven't got round to it!

[swguy]

Yep, that looks like what's needed. TY.

[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