I want to import an Excel (CSV, XLX, XLSX) file to my phpmyadmin databases. The file is 50 MB having around 5 million records. The issue is that whenever I try to upload that file, around 900 000 records are successfully inserted, but after that server shows an error of Exceeding Time Limit.
I also tried it by increasing max-execution-time of PHP.ini file but still, it shows the same error message. My Server is Hostgator.