In PhpMyadmin default settings creates problems when dealing with huge data , so here are the most common settings and you can change other setting while checking the configuration file.
By default you get a 2mb limit of upload / import size in phpmyadmin. That makes it odd and highly impossible to import larger files. You can increase the allowed upload size of phpmyadmin by editing your server's php. ini configuration file.
post_max_size = 800M
upload_max_filesize = 800M
max_execution_time = 5000
max_input_time = 5000
How do I increase max import size in phpMyAdmin?
How can I upload a large database in phpMyAdmin?
How do I increase MySQL database size in cPanel?
Watch video Settings: Change Max upload, Memory Limit & Input time in PhpMyadmin online, duration hours minute second in high quality that is uploaded to the channel Skill Kor 11 May 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,491 times and liked it 1 visitors.