CSV2MySQL

Forked from sanathp/largeCSV2mySQL.

A PHP script to import very large CSV file to MySQL database.

This script uploads a CSV up to 2 Million rows in 60 seconds.

Instructions

1. Create a table in your Mysql database to which you want to import
2. Grant the right permissions to the user who is going to connect
3. Open the PHP file from your localhost server
4. Enter all the fields
5. Click on upload button

The fastest way to import a CSV file is to use Mysql LOAD DATA command.

PS: server configuration might be reviewed (authorize file upload, file size, enable mysqli extension, enable 'LOAD DATA' query, ...).