This Php Script Will Import very large CSV files to MYSQL database in a minute
Mysql Server address/Host name ,Username , Database name ,Table name , File name are the Mandatory Fields
Instructions
1. Keep this php file and Your csv file in one folder
2. Create a table in your mysql database to which you want to import
3. Open the php file from your localhost server
4. Enter all the fields
5. click on upload button
Facing Problems ? Some of the reasons can be the ones shown below
1) Check if the table to which you want to import is created and the datatype of each column matches with the data in csv
2) If fields in your csv are not separated by commas go to Line 117 of php file and change the query
3) If each tuple in your csv are not one below other(i.e not seperated by a new line) got line 117 of php file and change the query