[BackupDB] Memory Allocation Failure

When I try to make a Website Template backup –- which is always easier to do a partial import because it adds the fieldnames to the insert queries -- on very large tables, then I get an memory allocation error. I can only up the memory up to a point, because the hosting runs slow if you allocate more memory to that PHP process, and you can only set that up once in the .htaccess file.

So, I've noticed that the extension doesn't write out every INSERT line seperately, but gathers them into a bundle for writing out for each table. This is the problem. If the extension will only write out every line to the file, line, by line, then there won't be a memory failure.

Hopefully the German developer will see this post.

Code:

---

Website-template creation ...

Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 5331845 bytes) in /usr/www/users/adven/system/modules/BackupDB/MakeWsTemplateRun.php on line 166

---

Hi Thyon,


the german user eS_IT has also written a new backup extension, but the existing extension has also (still) the problems with the memory limit leak and with the runtime of the script execution.

But he is already trying to change his extension the following ways:

- He changes the way of packing from tar.gz to zip
- He doesn't use PEAR components anymore
- He changes the script to a self calling script to avoid the problem with the runtime.

His extension is called eS_UnattendedBackup:

http://www.contao.org/erweiterungsli...000009.de.html

I wrote him that he should look at this script to be able to fix the "problems":

http://www.ruinelli.ch/projects/web/bysu

BYSU from George Ruinelli does not have these problems with the runtime of the script and memory leaks. I use it since 3 years without any problems at my german provider All-Inkl.com. Perhaps he can include George's solutions into his script... ;)

This is the original thread from the german forum:

http://www.contao-community.de/showt...868#post135868

only for completion...


Have fun.


Joachim

Hello thyon,

the file write within a database table for every INSERT INTO line will be available in new version for Contao 2.10.
I discuss some points with Leo and than the new version can be released.

Greetings from Berlin, Germany
Hagen

A new version 1.4.0 rc1 is released.
I think, that the memory limit produces no more errors by now.

Please check this rc1 and give feedback.

Greetings from Berlin, Germany
Hagen

also, some of these problems were created by isotope creating tons of cart entries, which was being exported, but I didn't even have a cart enabled, so there should be no entries.