Posted by C. on 12/12/06 12:57

applegreenss@gmail.com wrote:
> Is it possible to take the contents of a MySQL DB Table, and somehow
> put the data into a syntax-correct data file format like a delimited
> .txt file,

Yes - take a look at mysqldump, but it might be simpler to roll your
own.

> and using PHP parse it as a local c:\ file assuming it was
> sitting in C:\data.txt ..... so I want to read its contents in a
> similar method as you would query a DB table

Yes - IIRC there's an ODBC driver for CSV files (but the last time I
used it was about 10 years ago - maybe MS don't ship it any more).

>.... can you do this the
> same with a blob of data stored in a .TXT file?
>

Yes - but you'll need to encode it first. A better solution would be to
write each blob to its own file and reference the file from the table.

Although it is *possible* to do all this, it doesn't make a lot of
sense - a better solution would be SQLite or DBM.

C.

[Back to original message]