Hello. I face problem while uploading files because of its size. The default file import/upload size in phpMyAdmin is 2MB, For increasing
file import size You need to make some changes in php.ini file and
restart apache server. After changing following parameter you’ll able to
import big .sql file easily.
Here i am going to take example of ubantu LAMP server , find php.ini file and open it on any text editor.
if you are using any other server like WAMP, XAMPP similar find php.ini and open it on text editor
Find and Change these values in php.ini file.
Finally restart apache server and your new upload size will be visible on phpMyAdmin file import section, You you can upload larger file.
Here i am going to take example of ubantu LAMP server , find php.ini file and open it on any text editor.
sudo vim /etc/php5/apache2/php.ini
if you are using any other server like WAMP, XAMPP similar find php.ini and open it on text editor
Find and Change these values in php.ini file.
post_max_size = 1024M upload_max_filesize = 1024M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1024M
Note: don’t forget to allocate larger value to memory_limit then post_max_size.
Finally restart apache server and your new upload size will be visible on phpMyAdmin file import section, You you can upload larger file.
sudo service apache2 restart
No comments:
Post a Comment