Exporting data from sql to csv

[netfrugal]

I don't have a problem exporting data, but I do have a problem with size limitations.

I get a PHP Fatal error: Allowed memory size of........ bytes exhausted. (tried to allocate 50 byes) in........path to the file.

I'm not sure why I'm having such a problem with this. I use phpmyadmin and export from there with no limitation problems. Is there more to the exporting of data when it comes to size? I've exported the same data from phpmyadmin and the file size is 16 MB. Which doesn't seem so big to me.

And I place this in the top of the export script: ini_set("memory_limit","60MB");

Yet, I still have issues with it.

I've implemented the code from this site:

http://www.ineedtutorials.com/articles/export-mysql-data-to-csv-php-tutorial

Any help would be necessary
thanks!

[NogDog]

Looks like it grabs all the data and writes it in CSV format into a variable, then outputs that variable at the very end. From a memory standpoint, it would be much more efficient to output each line within that while loop instead of appending it to the $out variable. This would just require that you move all the header() commands before the start of the while loop, and then wherever you have a $out.= statement, just change it to an echo instead.