On 28 April 2011 07:00, Anush J.
<lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>
wrote:> 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 ?
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
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.