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 transportfile where sqlite aparently v2, not v1 thans all it works now, TRAC's WIKI is up and running again! On 12/12/06, Kees Nuyt [EMAIL PROTECTED] 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 transportfile 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] -
[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?
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] -
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] -