Page 1 of 1

single flat mysql database

Posted: Sat Jun 13, 2009 8:01 am
by isaac_cm
Hello,
Is it possible to create a single flat file mysql database ?

Thanks

Re: single flat mysql database

Posted: Sat Jun 13, 2009 12:04 pm
by califdon
isaac_cm wrote:Hello,
Is it possible to create a single flat file mysql database ?

Thanks
What do you mean? A database is not a simple text file, but if you mean can you have a single table in a database, of course the answer is Yes.

Re: single flat mysql database

Posted: Sat Jun 13, 2009 12:41 pm
by isaac_cm
No I mean like codegear interbase , firebird or sqlite

Re: single flat mysql database

Posted: Sat Jun 13, 2009 1:20 pm
by califdon
isaac_cm wrote:No I mean like codegear interbase , firebird or sqlite
Those are not mysql databases. You asked, "Is it possible to create a single flat file mysql database ? "

Re: single flat mysql database

Posted: Sat Jun 13, 2009 2:05 pm
by isaac_cm
maybe you did not understand me
I mean is there a feature in mysql to create single flat file db ?
"Is it possible to create a single flat file mysql database ? "
you miss the word "mysql"

Re: single flat mysql database

Posted: Sat Jun 13, 2009 2:41 pm
by califdon
isaac_cm wrote:maybe you did not understand me
I mean is there a feature in mysql to create single flat file db ?
"Is it possible to create a single flat file mysql database ? "
you miss the word "mysql"
I think we are not understanding each other.

MySQL is a relational database engine. Like every other relational database engine, it works with Tables. A database with one Table is sometimes referred to as a "flat file", meaning that it has no related Tables. But "flat file" is not a well defined term in database technology, and some people interpret it to mean a simple ASCII text file. If you are trying to ask, "can MySQL create an ASCII text file, such as a CSV (comma separated values) file?", the answer is that you can export data in CSV format, but then, it is not a MySQL file, it is a CSV text file. This is why you are having a problem getting an answer. You are asking a question using terms that have different meanings in the database world.