Skip to content
Advertisement

Exporting SQL table using phpMyAdmin gives no results for large data sets

When I open my table in phpMyAdmin and click Export (selecting .zip from the save-as options), I get an empty (0 byte) zip file. The table has ~200 000 records. This problem does not occur for smaller tables. This problem also does not occur when I export only the first 60 000 records.

Is this a bandwidth limitation? Is this something in my settings for MySQL?

Advertisement

Answer

This is potentially not a MySQL but a PHP problem, you might be exceeding the memory limit for a PHP script, try increasing memory_limit in the php.ini.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement