Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Kees Nuyt
On Wed, 13 Dec 2006 20:33:29 +0100, you wrote: >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.zi

Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Kees Nuyt
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

Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Use "sqlite" to read an sqlite version 2 database. Use "sqlite3" to read a version 3 database. Just a thought, but would it be worth detecting attempts to open v2 databases with sqlite3 and printing "this database appears to be version 2 and I'm version 3 so I can't op

Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Rob Coenen
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 wrote: On Tue, 12 Dec 2006 19:25:1

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread John Stanton
Could be an FTP in ASCII mode copy problem. [EMAIL PROTECTED] wrote: "Rob Coenen" <[EMAIL PROTECTED]> wrote: yes that is what I tried; I did use sqlite3 does not work. Any known problems on moving db files from Win to Linux? SQLite database files are cross-platform. They work on linux, wi

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Kees Nuyt
On Tue, 12 Dec 2006 19:25:16 +0100, you wrote: >ok - I was trying to do somthing like this, but I could not find any sample? sqlite3 olddatabasefile .dump >transportfile [transfer transportfile in binary mode] sqlite3 newdatabasefile On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote: >>

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread drh
"Rob Coenen" <[EMAIL PROTECTED]> wrote: > yes that is what I tried; I did use sqlite3 > does not work. Any known problems on moving db files from Win to Linux? > SQLite database files are cross-platform. They work on linux, windows, mac, various embedded platforms, etc. Byte order does not matt

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen
ok - I was trying to do somthing like this, but I could not find any sample? On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote: "Rob Coenen" wrote, > hello all, > > I have been using TRAC for Windows and I need to restore the TRAC wiki on > a > Linux machine. > > The integrated Tra

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen
yes that is what I tried; I did use sqlite3 does not work. Any known problems on moving db files from Win to Linux? On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Rob Coenen" <[EMAIL PROTECTED]> wrote: > hello all, > > I have been using TRAC for Windows and I need to restore the TRA

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread jose isaias cabrera
"Rob Coenen" wrote, hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I

Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread drh
"Rob Coenen" <[EMAIL PROTECTED]> wrote: > hello all, > > I have been using TRAC for Windows and I need to restore the TRAC wiki on a > Linux machine. > > The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite > version 3 (judging by opening the .db file with a HEX editor, the hea

[sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen
hello all, I have been using TRAC for Windows and I need to restore the TRAC wiki on a Linux machine. The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite version 3 (judging by opening the .db file with a HEX editor, the header mentions sqlite 3). I can read the file on Windo