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.
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
5) Restart Apache.
1) Open file php.ini
2) Search parameters upload_max_filesize.
3) Increase the file size limit for the parameter.
Now you can upload sql files up to 512 MB in phpmyadmin.upload_max_filesize=512M
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
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.
