How to import large CSV file to your Mysql or PHPMYADMIN

First you must create a file. with everything. i assume my filename is bigdump.php. and write this code:

<?php

mysql_connect('servername','username','password');

mysql_select_db('databasename');

$sql = "LOAD DATA LOCAL

INFILE 'data.csv'

INTO TABLE data

FIELDS

       TERMINATED BY ','

       OPTIONALLY ENCLOSED BY '\"'";

$insert = mysql_query($sql);

if($insert)

  echo 'success';

else

  die('error : ' . mysql_error());

?>

and now put in htdocs. and dont forget to move your csv file to htdocs too. and run it. TARAAA.. you got you want :)