How can you insert a text file into a mysql table with php?

[faydra92]

FIELDS ENCLOSED BY '"'
TERMINATED BY ','
LINES TERMINATED BY '\n' (IP_FROM,IP_TO,COUNTRY_CODE,COUNTRY_NAME);

file is log.txt

[HalfaBee]

You can try using the LOAD DATA INFILE function of mysql.

From the systax you have tried and had no luck.

So write a little script.
For example. ( completely untested )

$data = file( 'log.txt' );

$data = str_replace( "\n",'',$data ); // get rid of \n

foreach( $data as $s )
{
    $fields = explode( ",",$s )
    $sql = "INSERT INTO table_name ( $field[0],$field[1],$field[2],$field[3] )";
    if( mysql_query( $sql )===FALSE )
    {
        echo 'error in sql'.mysql_error();
        break;
    }
}