You could use mysqlimport with --fields-terminated-by=";"
or you could open it in something like Excel, parse it there (text to
columns), and save it as a CSV
or you could read it line by, line into PHP, explode each line on the
;, then insert the data into MySQL
or you could write a script tha
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> Hello Mark,
>
> I have tryed it by splitting the file into pices and then insert it with the
> help of phpmyadmin. This woked.
>
> however, I do have some more files to upload, and this seems to be not the
> fastest way:-)
>
> I tryed
Hi there,
I have a data file with data seperated by semicolons. It is about 8MB big.
Now I just want to import it into mysql.
I tryed several things. First I took phpmyadmin, which resulted in a white
page without error msg. Then I tryed it by hand with load data. This did not
work as well. No I
Hello Mark,
I have tryed it by splitting the file into pices and then insert it with the
help of phpmyadmin. This woked.
however, I do have some more files to upload, and this seems to be not the
fastest way:-)
I tryed this:
mysql> LOAD DATA INFILE 'Hotel_Description.txt'INTO TABLE
test.hot
