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 change the field accordingly (username, password, db_name, csv_import.csv)
mysqlimport --ignore-lines=1 --lines-terminated-by='\n' --fields-terminated-by=',' --fields-enclosed-by='"' --verbose --local -uusername -ppassword db_name csv_import.csv