On Wed, 13 Dec 2006 16:00:22 +0100, Rob Coenen wrote:
>Kees,
>
> thanks this helped me a lot. It turned out the DB was
> actually in sqlite V2 so I did a
>
> sqlite3 olddatabasefile .dump >transportfile
>
> end then transported the transportfile in a ZIP
> (binary safe) to the Linux machine where I did a
> sqlite newdatabasefile <transportfile
> where sqlite aparently v2, not v1
Good idea to use zip or similar, not only for binary safety, but
also because the correctness of the transport is checked by CRC.
> thanks all it works now, TRAC's WIKI is up and running again!
I'm glad it worked for you.
>> > ok - I was trying to do somthing like this, but I
>> > could not find any sample?
The page where this is documented :
http://www.sqlite.org/sqlite.html
is quite hard to find, the only link i found is on the
http://www.sqlite.org/download.html
page, next to the "Precompiled Binaries For Windows"
sqlite-3_3_8.zip link. Which is very appropriate, but a bit
modest ;)
>> sqlite3 olddatabasefile .dump >transportfile
>> [transfer transportfile in binary mode]
>> sqlite3 newdatabasefile <transportfile
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
