Increase import file size limit in phpmyadmin

Upload large size sql files in phpmyadmin :

1) Open file php.ini

2) Search parameters upload_max_filesize.

3) Increase the file size limit for the parameter.

upload_max_filesize=512M

Now you can upload sql files up to 512 MB in phpmyadmin.
In this example I have set limit 512 MB, you can set according to your requirement.

4) Increase file size limit for post_max_size and memory_limit too.
     It should be equal or greater than upload_max_filesize

post_max_size=1024M
memory_limit=1024M

5) Restart Apache.

There is a instruction in php.ini that "Maximum amount of memory a script may consume (128MB)" but when you will increase the memory_limit size greater than 128M, you will see that you are not getting any error and large file has been uploaded successfully.

NOTE :
The first things to check are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. post_max_size and memory_limit need to be equal or larger than upload_max_filesize.

Be careful to set memory_limit size. If it exceeds the limit, the phpmyadmin does not start. It shows blank page.

If you are not able to upload small size sql file (in-kb/mb) because of change in  memory limit. Make it again 128 MB and Restart Apache


Solution :2
If you are still facing problem while uploading large size sql files, upload them using command line. To see this method, click here .

You should see this post too. Click here.

phpmyadmin error : #1153 - Got a packet bigger than 'max_allowed_packet' bytes

 phpmyadmin- Got a packet bigger than 'max_allowed_packet' bytes

 


Error in phpmyadmin while uploading sql file :

1) Open file my.cnf 
path of the file : /opt/lampp/etc/my.cnf

2) Set value max_allowed_packet=128M under attribute [mysqld] 
    If parameter is not there, add it under attribute [mysqld] .

[mysqld]
max_allowed_packet=128M

3) Restart XAMPP.




phpmyadmin - Fatal error : allowed memory size of bytes exhausted

Fatal error: Allowed memory size of bytes exhausted (tried to allocate bytes)

If you are not able to open phpmyadmin because of this error, follow the steps to remove it.

1) Open file php.ini
xampp : /opt/lampp/etc/php.ini
apache2 (Debian) : /etc/php5/apache2/php.ini 
httpd (RHEL) : /etc/php.ini

2) Search parameter memory_limit. By default it's value is 128M.

    Increase the value according to size of parameters upload_max_filesize and post_max_size.

memory_limit = 512M

3) Restart Apache.

There is a instruction in php.ini that "Maximum amount of memory a script may consume (128MB)" but when you will increase the memory size greater than 128M, you will see yourself that error is gone.


NOTE :
The first things to check are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. post_max_size and memory_limit need to be equal or larger than upload_max_filesize.

Be careful to set memory_limit size. If it exceeds the limit, the phpmyadmin does not start. It shows blank page.

You have increased the memory limit but you still get this error frequently. Restart the Apache will solve your problem. If you are working on live Linux server and it does not restart frequently. You might get this error too often, make a Crontab for daily Apache-Restart will solve your problem.