Import large CSV file using command line rather than using phpMyAdmin or other GUI software. Importing CSV file using command line is much faster, you can import 100000+ rows in seconds which is not possible in phpMyAdmin. Table name should be same as the CSV file name. Use this command in your command line. Please … →