[SOLVED] uploading data from flat file to MySQL

Hello all,

How would you go about uploading a flat file to MySQL database table? the file is 210mb big and is a fixed width file?


Open the file for reading, read the contents, close the file.
Open a db connection, run an INSERT query, close the connection again.

Or is there a certain structure in the text file which defines how the data in the text file should be inserted into the table(s)?

this is resolved, how do I mark this post and some others

Users should have the ability to “EDIT” their own posts.

If you chose EDIT (on the very first post) you can then ALTER the subject and append a [SOLVED] to the BEGINNING of the subject.

Please do not alter anything else within the post as it may (or may not) be useful to someone else.

Sponsor our Newsletter | Privacy Policy | Terms of Service