Backup MySQL Database

[NWCE]

Thanks Steve....I will give this a go and let you know!

[NWCE]

Hi Steve,

I tried the newest branch this morning. Before installing the newest version, I Uninstalled the previous version using both the Uninstall and Clean Up functions through the Admin->Modules->Plugin Mgr and verified this by looking in the zc_plugin folder and saw the empty BackupMySQL folder.

I then uploaded this newest branch version to the zc_plugins folder, and installed it through the Admin->Modules->Plugin Mgr

I backed up my current live site, placed this gzip file in my development site Admin/backups folder and then went to the plugin in Admin.

I selected this database file, used the Restore button and it began whirring....but did not insert the new database. I received this error at the top of my Admin panel:
ERROR: FILE NOT FOUND: [C:\Windows\Temp\php7FB4.tmp]

And this error in my Debug logs:

PHP Warning: rename(C:\Windows\Temp\16787D3.tmp,C:\Windows\Temp\php7FB4.tmp): Access is denied (code: 5) in C:\wamp64\www\new2121\zc_plugins\BackupMySQL\v2.0.0\admin\backup_mysql.php on line 666.

Is there an adjustment I need to make??

[torvista]

You don't need to uninstall/install...but you need to get the update I did this morning when I found that issue!

Always worth having a GitHub account if only to "watch" the repositories of all the plugins you have, to get updates hot off the press.
And, see the activity in Zen Cart, most of which does not get a mention in the forum.

[NWCE]

Thanks for the heads up on the newer-newer version!

I just downloaded, installed and ran it. You did it!

I successfully uploaded my current live site database as a gzip file.....perfect!

Thank you for your continued work to make this plugin work.

Much Appreciated!!

[torvista]

About time!

FYI all this out of memory stuff was due to the solution I'd arrived at to deal with this bug:

https://github.com/torvista/Zen_Cart...lugin/issues/6

[NWCE]

Ha,ha....not at all!

It takes time to work through the variables. Thanks for sticking with it!

[NWCE]

I had one more error crop up.....

I have now moved my development site to my server (under a subfolder)...copies the database from my development site (using PhPmyAdmin->Import).

When I log into my Admin the plugin is uninstalled. I then installed it and received the confirmation in the green bar in my Admin panel. When I go to test it, I click on it in Admin->Tools and I get a white screen and here is my Debug Log error:

PHP Fatal error: Uncaught TypeError: trim(): Argument #1 ($string) must be of type string, null given in /home/mysite/public_html/new210/zc_plugins/BackupMySQL/v2.0.0/admin/backup_mysql.php:230
Stack trace:
#0 /home/mysite/public_html/new210/zc_plugins/BackupMySQL/v2.0.0/admin/backup_mysql.php(230): trim()
#1 /home/mysite/public_html/new210/admin/index.php(28): require('...')
#2 {main}
thrown in /home/mysite/public_html/new210/zc_plugins/BackupMySQL/v2.0.0/admin/backup_mysql.php on line 230.

Can this be as my test site in WAMP has PHP v.8.2.18 and SQL/Maria DB v.11.3.2 and my server subfolder site has PHP v 8.2.27 and SQL/MariaDB v. 10.6.19

Sorry about this go around....

I have uninstalled and reinstalled 3 times, just to insure its not user error. I have taken the folder from my test site (which we got working this morning) to place into zc_plugins to insure I have the newest, newest version and not a previous one. (Trying to rule out user error).

The one weird thing is in my Admin->Modules->Plugin Mgr in my test site, it shows this plug in file space as 78.56kB and on my server subfolder site the file space is 134.56kB. This never seems to change with all of the install and uninstalls that I have done. I have used the Clean Up Tool and Uninstall in Plugin Mgr and insure that it is completely removed from the folder before uploading the fileset once again and installing. This must have something to do with it?!

Any thoughts??

[jodean]

Installed Zen_Cart-Backup_MYSQL_Plugin-main and it installed using your instructions but when I run it I get errors.

Result code: ($dump_results) 1
console $output: [0] => "'unknown' is not recognized as an internal or external command,

console $output: [1] => "operable program or batch file.

Failure: The database has NOT been saved.
2 debug-log files exist, click here to view.
MySQL tools (mysql, mysqldump) not found.

Error Log
[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(390): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Undefined variable $rInfo in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 390.

[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(390): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Attempt to read property "reviews_id" on null in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 390.

[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(392): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Undefined variable $rInfo in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 392.

[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(392): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Attempt to read property "products_name" on null in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 392.

[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(393): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Undefined variable $rInfo in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 393.

[10-Feb-2025 21:25:33 Europe/Berlin] Request URI: /tennesseetraditionalflies.com/fishing/index.php?cmd=reviews&status=1&rID=62&action=delete, IP address: ::1, Language id 1
#0 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php(393): zen_debug_error_handler()
#1 C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\index.php(16): require('C:\\xampp\\htdocs...')
--> PHP Warning: Attempt to read property "reviews_id" on null in C:\xampp\htdocs\tennesseetraditionalflies.com\fishing\reviews.php on line 393.

[torvista]

Those error logs don't appear to have anything to do with the backup.

You are on a local server. Windows/Unix? What LAMP environment?

Add &debug=ON to the url and refresh the page, you'll see the list of places where the script is trying (and failing) to find the mysql tools.

You'll need to add the correct location on your server to the list in $pathsearch at line 254 \zc_plugins\BackupMySQL\v2.0.0\admin\backup_mysql.php

[jodean]

Those error logs don't appear to have anything to do with the backup.

You are on a local server. Windows/Unix? What LAMP environment?

Add &debug=ON to the url and refresh the page, you'll see the list of places where the script is trying (and failing) to find the mysql tools.

You'll need to add the correct location on your server to the list in $pathsearch at line 254 \zc_plugins\BackupMySQL\v2.0.0\admin\backup_mysql.php

############################################################

I am running on XAMPP in development and production on SITEGROUND hosting.