importing a csv into the db

[eluser]ray73864[/eluser]
yeah, that's because mysql can't read from that directory, so using the very first reply i posted (that had code), do the 'copy' thing first to /tmp/ and it will all work fine.

also with regards to the file structure thing, when i did mine using 'load data infile' i was 100% guaranteed that the file would be the same everytime since it was a data export from MSAccess (all columns from the table).