[RESOLVED] databae/flat file

[QuizToon]

Hi all,

Not sure about his question but here goes anyway.

I have a MySql database and a piece of code to read and process information from that database.

If I want to pu this database and its information onto a cd or dvd, how can it be done. Or mayabe I should ask can it be done and what is the best way/format to do it.

For example, say I had a simple guestbook actually on the web and I wanted to keep that information on a cd what is the best way to do it. I dont need to be able to add any more entries to the database, just read what is there already.

Hope you understand what I am asking.

Thanks in advancce

[sneakyimp]

there are a number of ways to get data out of a mysql database.

if you have access from the command line, you can use msqldump:
http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

by default that option outputs the data as SQL statements...i don' t know if you can do it in CSV or tab-separated data format.

if you have access to the db with phpMyAdmin, you can export the data in a variety of formats. just look around.