Instiki users - Apr 2006 - [Instiki] backing it all up

Relative to Instiki 0.11.0, does anyone know how to back up the data, and  
restore it as well? Is it as simple as grabbing the  
"..\instiki\db\production.db.sqlite3" file, then putting it back into
a
new install of Instiki, if need be?

This surely would be a useful thing to have documented somewhere.

-- t.

===============================================Tom Cloyd, MS MA, LMHC
Private practice Psychotherapist
Bellingham, Washington, U.S.A: (360) 920-1226
<< TC.BestMindHealth.com / BestMindHealth.com >>
<< tomcloyd at bestmindhealth.com >>
================================================

On Wed, 2006-04-05 at 16:04 -0700, Tom Cloyd wrote:
> Relative to Instiki 0.11.0, does anyone know how to back up the data, and  
> restore it as well? Is it as simple as grabbing the  
> "..\instiki\db\production.db.sqlite3" file, then putting it back
into a
> new install of Instiki, if need be?
Yes. 
If you have file uploads enabled, you''ll also need instiki/public
directory (that''s where the uploaded files are).
> This surely would be a useful thing to have documented somewhere.
Yes. :)

Alex

Alex,

Thanks VERY much. I''ll be happy to document this at Instiki.org (where,
last I looked, it is not documented), and pass it on to TextDrive and ask  
that it gets included in their knowledge base. This is so delightfully  
simple, and thus congruent with much of the rest of Instiki (although I  
suppose this simplicity is actually due to how Rails works, in truth).

I''m still just a bit confused about something, however. In my Instiki  
instance, I have a parent wiki, which has spawned a number of child wikis,  
so to speak. Looking at the directory structure on the server, what I see  
is just ONE sqlite3 db file (well, of course - not need for more, yes?).  
That contains ALL the wikis, yes? And, just to be very very clear, ftping  
that file to my Windows desktop, from the (I think) BSD OS at TestDrive,  
can that db file be dropped into a fresh Windows install of Instiki, or  
must it go back only to an Instiki running under the same OSas that from  
which it came?

Sorry to be so ignorant, but I haven''t had time to learn everything yet
-
still working on it!

Thanks for any help you can offer.

Tom C.

On Wed, 05 Apr 2006 22:11:58 -0700, Alexey Verkhovsky <alex at verk.info>
wrote:
> On Wed, 2006-04-05 at 16:04 -0700, Tom Cloyd wrote:
>> Relative to Instiki 0.11.0, does anyone know how to back up the data,  
>> and
>> restore it as well? Is it as simple as grabbing the
>> "..\instiki\db\production.db.sqlite3" file, then putting it
back into a
>> new install of Instiki, if need be?
>
> Yes.
> If you have file uploads enabled, you''ll also need instiki/public
> directory (that''s where the uploaded files are).
>
>> This surely would be a useful thing to have documented somewhere.
> Yes. :)
>
> Alex
>


-- 

===============================================Tom Cloyd, MS MA, LMHC
Private practice Psychotherapist
Bellingham, Washington, U.S.A: (360) 920-1226
<< TC.BestMindHealth.com / BestMindHealth.com >>
<< tomcloyd at bestmindhealth.com >>
================================================

On Thu, 2006-04-06 at 00:08 -0700, Tom Cloyd wrote:
> In my Instiki  
> instance, I have a parent wiki, which has spawned a number of child wikis,
> so to speak. Looking at the directory structure on the server, what I see  
> is just ONE sqlite3 db file (well, of course - not need for more, yes?).  
> That contains ALL the wikis, yes? 
Yes.
> And, just to be very very clear, ftping  
> that file to my Windows desktop, from the (I think) BSD OS at TestDrive,  
> can that db file be dropped into a fresh Windows install of Instiki, or  
> must it go back only to an Instiki running under the same OSas that from  
> which it came?
I seem to remember that it doesn''t work that way, but I''m not
sure. If
you find it out, please post about it here.

Best regards,
Alex