I'm trying to export a database by first selecting it and then going to the "Export" tab.
I've exported dozens of databases literally thousands of times before, from several servers with different phpmyadmin versions and it's the first time I face this problem, but with this particular database it's 100% systematic.
When I choose "quick" and click "go", download finishes immediately (I must admit it is quick), and the downloaded file is 0 (zero) bytes in size.
I guess the problem is probably related to the fact that the amount of data in the database is relatively big. There is a table with more than 65k records. However
What is unacceptable is that you get an apparently succesful download of a 0-byte file without an error message.
And here's the error message in the server log:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128204800 bytes) in /opt/lampp/phpmyadmin/export.php on line 378, referer: http://localhost/phpmyadmin/
OMG, I can't believe phpmyadmin is trying to keep the whole database dump in memory!!!
phpMyAdmin 4.0.4 is out of date. From the ChangeLog of 4.0.6:
"bug #4046 Exporting huge Tables causes memory-Problems"