Wednesday, March 24, 2010

Increase Limit on Dumpfile Size in MySQL

If you are using wamp server, please do the following:

> sudo gedit /etc/php5/apache2/php.ini

Modify
a) post_max_size
b) memory_limit
c) upload_max_filesize

In an order memory_limit > post_max_size (size greater than required DB) > upload_max_filesize Restart apache.

If you are using MySQL alone, please modify your "my.ini" file. If you cannot find such a file, please make a copy of your "my-medium.cnf" file and rename it to "my.ini". You'll find "max_allowed_packet" variable. Then change its value to a larger one you need!!!

No comments: