Backup MySQL Database

[NWCE]

My current live site database that I have imported into my development cart is:

MariaDB dump 10.19 Distrib 10.6.19-MariaDB, for Linux (x86_64)

MySQL version in my WAMP is 8.3

Thanks again for your continued help.

[torvista]

Try this branch...

https://github.com/torvista/Zen_Cart...tree/maria_bug

whereas I previously needed 448M...it now works with 32M!

[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??

[NWCE]

Hi Steve,

Been working on getting this plugin working once again....and have inputted a newer version of my live site DB into this test site. I still have the latest version of this plugin installed (from 5 days ago on Github).

Once my DB is in and I've run the zc_installer to update the DB, I have tried..#1 just using the Install button in Admin->Plugin Mgr and #2 tried uninstalling the files via FTP and then reinstalling and then Installing the plugin via Plugin Mgr.

I get the green stmt at the top of my Admin saying it has been installed and good to go.

I then go to Admin->Tools to use/test it and when I click on it, I get an Admin white screen with the following error in my Debug Logs...

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

It also shows the file space in Plugin Mgr as 134.56kB...whereas when I got it running in my test site in my local computer...the file space was only 78.56kB It appears to have fragments of an older version. When in Admin->Plugin Mgr, when I choose Clean Up....the only option is remove this current plugin v2.0.0

Can you point me in the right direction as to where I've gone wrong???

Thanks!