Quick database question

[Shane Litherland]

Hi Colin,

I don't bother with all that hard work ;-) twas just an idea.. i'm fine
backing up my db's from a simple command-line..
guess there's nothing wrong with an xml backup, I was thinking along
lines of if one needs to resort to a backup, then it may mean the whole
database needs restoring, which may have been quicker from a db backup
file. But as another user has noted, there's more to db backups than
that...

regards,
Shane


On Mon, 2010-12-27 at 11:37 +0000, Colin Law wrote:
> On 27 December 2010 11:05, Shane Litherland <litherland-farm at bigpond.com> wrote:
> > ...
> > e.g. a bit of program that had
> >
> > IF database is postgres, THEN send "pg_dump with filename as current
> > file+timestamp+the-word-backup" to the postgres db, using user/login
> > that the user saved in their preferences or typed in the GUI for this
> > task; and save it in the location that user specified in prefs/GUI;
> >
> > OR, IF sqlite, then do same steps for it;
> > or ...etc
> >
> > and have a GUI that the user ticks which db they use, and other optional
> > bits as I alluded to above
> >...
> 
> Why bother with all this hard work?  What is wrong with File > Save
> Backup saving an XML format file?
> 
> Colin