export large database mysql phpmyadmin

Question

I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:

Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)

Any idea how to solve this problem?!

Thanks :)

Answer 1

I would suggest to try using the command line and the mysqldump.exe utility, as suggested here