Increase import file size in phpmyadmin

open php.ini from /opt/lampp/etc location


i.e.    /opt/lampp/etc/php.ini            //    file location


then find for     :    post_max_size


change the size in mb such as you want 512mb file size limit so type 512M


then again find for :    upload_max_filesize



similarly change the size in mb such as you want 512mb file size limit so type 512M


now save the file and restart the xampp


in ubuntu type on terminal to restart the xampp


sudo /opt/lampp/lampp restart