Backup MySQL Database

[NWCE]

In using the plugin to Restore a newer version of my database to my upgrading site today, I encountered this error.....

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 454834832 bytes) in /home/mysite/public_html/new210/zc_plugins/BackupMySQL/v2.0.0/admin/backup_mysql.php on line 620

I am using a .gz file from my current site, dropped into the Admin->backups folder as usual. I wasn't able to find the area in this file to increase the allowable file size....would you be able to point me in the right direction?

Thanks!

[lat9]

In using the plugin to Restore a newer version of my database to my upgrading site today, I encountered this error.....

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 454834832 bytes) in /home/mysite/public_html/new210/zc_plugins/BackupMySQL/v2.0.0/admin/backup_mysql.php on line 620

I am using a .gz file from my current site, dropped into the Admin->backups folder as usual. I wasn't able to find the area in this file to increase the allowable file size....would you be able to point me in the right direction?

Thanks!

A guess, since I don't use this plugin: Configuration / Maximum Values / Maximum File Upload Size

Barring that, what shows for PHP Memory Limit when you display Tools / Server/Version Info?

[torvista]

Looks like a memory limit, not a filesize limit.

...and I have comments on 620...you using the latest version?

[NWCE]

Thank you lat9 for your reply and suggestions! My max file upload size it the default of 2048000 and my PHP memory limit is 512M. It appears these values should work...but let me know if I'm missing something.

Thanks as well Torvista for your reply and yes, I am using the latest version of yours from Github...which is also why I'm posting as you mentioned you'd like to have real use feedback. As I had removed all of the debris from my last errors we discussed a few posts ago....I was thinking that this shouldn't be an issue???

What else would you suggest?

[torvista]

So you can backup as a .gz from your production store but not restore...on the same server?

Can you backup/restore as a .zip?

What size are the files?

[dysfunctional]

Just downloaded from github and tested on my local webserver (ubuntu 24.04) with zen cart 2.1.0 and php 8.3. Worked for me without any issues. Nice work!

[NWCE]

Thanks again for your reply Torvista. Yes, this is correct...I can backup, but when I try to restore is when I get this issue. This production site is in a sub folder on my live site server now...so this is where I am testing once again with my current store database in this environment.

I have just tried backing up as a .zip file in this test site and all worked perfectly. File size is 68,896Kb.

I am then saving my live site database, placing it in the Admin->Backups folder in my test site and then trying to restore it in. On my live site, I am using this same plugin (version 1-5g)for Zen Cart v.1.5.8. It does not have the option to save as just a .zip file. Can only save as .gz or pure SQL

[torvista]

Confused.

Your test site and your production site on the same server.
One would assume they have the same limits and php extensions.

But the test one offers .zip backup and restore (since it has detected the extension) but the production does not.

Perhaps you should compare the phpino (version info) for both sites for one thing.

As for runnng out of memory, you could put a higher memory limit value in an ini_set at the start of the backup script to test.

Perhaps the previous poster could indicate what format he used, the filesize and the server memory limit.

My file is only 25MB.

[NWCE]

Thanks for your reply Torvista....

Sorry if my post was confusing.....it seems like there are many things at play here.

I was thinking overnight....and I thought I should just start from scratch if others are not experiencing any issues.

I made a fresh install of ZC v.2.1 and a new database in my local computer. I did not install my merged custom files first.....I tried installing the plugins (only the ones that use the zc_plugins folder to install) first and have had success with this install. I then tried Backup (nothing much in the database, just the demo info) and then used this backup to try the Restore function in the plug in and it all worked perfectly.

I will now progress on installing my merged custom files and other addons and will continue to backup and restore with each addition to see if/where it breaks.

Thank you for your help with this and I will reply once I have installed the rest and what my results are.

[NWCE]

Hi again Torvista....now that I have progressed in my development site to installing all Addon plugins and testing to insure I have no errors....I went to the last step of installing a copy of my live site database into this development site.

In using the latest version of this plugin and using the plugin to install my v.1.5.8 live site database I received the error once again about size limits.

Allowed memory size of 134217728 bytes exhausted (tried to allocate 455462288 bytes) in C:\wamp64\www\new2121\zc_plugins\BackupMySQL\v2.0.0\admin\backup_mysql.php on line 612

It is a 70Kb database (not sure if that's deemed as large). While I was able to successfully Backup and Restore the database when it only contained the stock demo data....as soon as it is larger....I get this error and am unable to use this plugin to get my database in. I have then resorted to using the Import function in PhPMyAdmin.

Would you be able to point me in the right direction on how to fix this memory issue?

Thanks!