Re: How to package a database (not program)?
On Thu, 2003-12-11 at 23:30, Matt Zimmerman wrote:
> What if I want to import the data into a MySQL database? Is it trivial to
> do that from an SQLite data file? If not, I think it would be a good idea
> to provide the master format as well (SQL? tab-delimited?).
Yes, it looks like it is trivial. SQLite has a "dump" command, which
can be issued on the command line, that exports the data as a text file
of SQL commands. This is more useful than the master format, which is
delimited by '^' and '~', and lacks table descriptions.