Re: [sqlite] sqllite ddb from win to linux
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: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: >> >> "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 can read the file on Window with sqlite but I cannot read the same >> file >> > when I copy it to my Linux machine. It says that the file is not a >> > database >> > or that it is encrypted. >> > >> > Any help here? >> > >> The first thing that comes to mind is to dump the database to text and >> then, >> open a new one in unix and import it. >> >> just thinking... >> >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> >> - >> >> -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
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 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 Window with sqlite but I cannot read the same file > when I copy it to my Linux machine. It says that the file is not a > database > or that it is encrypted. > > Any help here? > The first thing that comes to mind is to dump the database to text and then, open a new one in unix and import it. just thinking... - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
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 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 Window with sqlite but I cannot read the same file > when I copy it to my Linux machine. It says that the file is not a database > or that it is encrypted. > > Any help here? Use "sqlite" to read an sqlite version 2 database. Use "sqlite3" to read a version 3 database. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqllite ddb from win to linux
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 Window with sqlite but I cannot read the same file when I copy it to my Linux machine. It says that the file is not a database or that it is encrypted. Any help here?