Tuesday, July 30, 2013

Increase Size of import SQL File in phpmyadmin


Modify php.ini

Open text pad, enter


Save as .php on your local machine
Navigate to this file using any Browser
Find
Configuration File (php.ini) Path/usr/local/php5/lib




Open Terminal
Paste: nano /usr/local/php5/lib/php.ini

Modify output buffering
search for "output_buffering" without the quotation mark
change the value to on
restart apache service

Find: (Ctrl + W)
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Restart Apache service: sudo apachectl restart

No comments:

Post a Comment