export large database mysql phpmyadmin

mysql phpmyadmin fatal-error
ahajib picture ahajib · Nov 17, 2013 · Viewed 49.4k times · Source

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

user2196728 picture user2196728 · Nov 17, 2013

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

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys. I created …

Read More