Hello Guys,
This post will help you to increase the import size limit in phpMyAdmin. Please note guys this is not about upload_max_filesize in php.ini. Below is an image which will clear you about import file size.
(https://www.milesweb.com/hosting-faqs/wp-content/uploads/2014/12/11-25-2014-5-12-57-PM.png)
In above image you can see that red arrow showing the improt file size i.e (Max: 50MiB)
If you are using WHM/Cpanel then to change that "Max: 50MiB" limit in the import section of phpmyadmin, you will have to change two values in WHM.
Login to WHM with root user.
1. Go to Tweak settings, find the "cPanel PHP Max upload size" change it according to your needs. Click on the Save changes.
2. Go to Tweak settings, find the "cPanel PHP Max POST size" change it according to your needs. Click on the Save changes.
Now go to your phpMyadmin, you can see the value that you have set in import section.
Enjoy !!