I had a similar problem the other day. The problem with your file is that MySQL doesn't know where each field starts and ends. If you had a comma deliminated file, it might work, but I did it another way.
I used a php script to read the file line by line and used "substr()" to seperate the line variable into different variables (one for each column), then add each of those variables to the database before reading the next line. The text file I was working with was 12Mb and contained over 34,000 lines, and it seemed to work fine for me, so you could probably do the same.
Here's the script that I threw together which you could adapt to work for you.
<?php
mysql_connect("localhost", "USERNAME", "PASSWORD")
or die ("Unable to connect to database.");
mysql_select_db("DATABASE")
or die ("Unable to select database.");
$handle = fopen("YOURFILE.TXT", "r");
while (!feof ($handle)) {
$buffer = fgets($handle);
$col1 = substr("$buffer", 0, -23);
$col2 = substr("$buffer", 6, -13);
$col3 = substr("$buffer", 16);
$query = "INSERT into TABLENAME values ('$col1', '$col2', '$col3')";
$result = mysql_query($query);
if(!$result){
die(mysql_error());
}
}
fclose ($handle);
?>
You'll obviously have to modify my substr statements and add some to get it to work for you, but that should work once you've modified that.
