OT: database advice
Les Mikesell
lesmikesell at gmail.com
Mon Apr 25 05:35:35 UTC 2005
On Sun, 2005-04-24 at 16:08, Duncan Lithgow wrote:
> I understand about what sql is and isn't.
>
> Okay, so different db's store data differently, fair enough, how can i
> save a copy of the db contents though, and in what format should I do
> that.
>
> I believe it can be done with a csv list, but that sounds a bit foolish
> to me. There must be a better way.
Mysql and postgresql both include commands to dump a database in
the form of the sql commands to reconstruct it (create the tables
and insert the data). This can be used to migrate between databases
or between updates that change the table storage format.
--
Les Mikesell
les at futuresource.com
More information about the users
mailing list