[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: OT: database advice



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 futuresource com



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]