Error: Download Database Backup

[palseif]

Hi i tried to use the "Download Database Backup" tool but i doesn't work.

This is my "Output System Information":

---

Server Information

Web Server Software = Apache/2.2.21 (Unix) DAV/2 mod_ssl/2.2.21 OpenSSL/1.0.0c PHP/5.3.8 mod_apreq2-20090110/2.7.1 mod_perl/2.0.5 Perl/v5.10.1 PHP Version = 5.3.8

Software Information

FoOlSlide Version = 0.8.6 Environment = Development

PHP Configuration

php.ini Location = /opt/lampp/etc/php.ini Safe Mode = Off Allow URL fopen = On Max Execution Time = 300 File Uploads = Enabled Max POST Size = 32M Max Upload Size = 50M Max File Uploads = 20

Extensions

cURL = Installed GD2 = Installed ImageMagick = Installed

Report Generated: Sat, 15 Oct 11 22:02:42 +0200

---

And this is the error: "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 256 bytes) in /opt/lampp/htdocs/system/database/drivers/mysql/mysql_result.php on line 147".

Best regards, palseif.

[woxxy]

It seems that your database is too large for your RAM dedicated to PHP, which is weird, considering FoOlSlide databases are usually less than 5mb large.

Are you sharing a database with another application? In example, same database for your blog and FoOlSlide.

[palseif]

No i am not sharing my database with a nother application. And I have 2Gb of Ram on my server.

[woxxy]

Try want to increment your PHP allowed RAM use to 256M then, your server can easily take it. See the informations panel for knowing which variable it is in your PHP file, and then restart PHP. If you are able to export the file then, report back with the size of the generated file.

[palseif]

I have tried with 256M and it gived me this error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 6 bytes) in /opt/lampp/htdocs/system/database/drivers/mysql/mysql_utility.php on line 99

And after that i changed it to 512M and it worked. The database is 2,23M zipped and 40M unzipped.

[woxxy]

That's a strangely large size for a database. Are you able to enter your MySQL manager (usually phpMyAdmin) and see how much are your FoOlSlide tables occupying?

Also, reduce the RAM back to 256, or you'll risk instability.

[palseif]

I reduced the RAM back to 256, and here its a print screen from phpmyadmin:

http://imageshack.us/photo/my-images/839/foolslide.png/

Now its, ok i dont know why but it works with 256M RAM (maybe i forgot to restart it).

Thanks.