sqlite db transfer

rubyonrails-talk
#1

Hi all,
My question is related to the sqlite db I'm using with my rails app.
I was thinking if its possible to save the file
(ROR_DIR/db/development.sqlite) and then if somehow the db gets erased
or if I do a rollback and then a migrate can I retrieve my information
by copying the file back to the same location ?

Since I'm hosting the app from my linux box and most of colleagues use
it, I would like to make copies of my database periodically, I'm scared
about losing all the information. Is there a way to do this ?

Can anyone please suggest a solution..

Thanks in advance
Anush

#2

The .sqlite file is just a file like any other. You can back it up
using your normal backup mechanism and if necessary just restore the
file from your backup.

Note though that sqlite is not really appropriate for a production
environment. In particular I believe it does not cope with multi user
well.

Colin

Colin