Knowledgebase
When dumping a large table in compressed mode, I get a memory limit error or a time limit error.
Compressed dumps are built in memory and because of this are limited to PHP's memory limit. For GZip/BZip2 exports this can be overcome since phpMyAdmin 2.5.4 using $cfg['CompressOnFly'] (enabled by default). Zip exports can not be handled this way, so if you need Zip files for larger dump, you have to use another way.
Also Read
-
With InnoDB tables, I lose foreign key relationships when I rename or alter a table. (Views: 5559) -
I cannot use (clickable) HTML-forms in fields where I put a MIME transformation onto ! (Views: 5429)
-
When using HTTP authentication, an user who logged out can not relogin in with the same username. (Views: 5506)
-
I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution. (Views: 6743)
-
The number of records for InnoDB tables is not correct. (Views: 6343)