'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?

sqlphpmyadmin


Solution 1:[1]

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.

Solution 2:[2]

Also, you can directly exporting by using cmd in the dir of that database instead of exporting using the phpMyAdmin UI.

C:>mysql -u username -p password database_name < filename.sql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 N'Bayramberdiyev
Solution 2 N'Bayramberdiyev

Related Questions