Re: [sqlite] sqllite ddb from win to linux
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.zip link. Which is very appropriate, but a bit >modest ;) Oops, there's another link on http://www.sqlite.org/quickstart.html as well: "Additional documentation is available here " -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
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 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
Re: [sqlite] sqllite ddb from win to linux
[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 open it" rather than "database corrupt"? Martin - To unsubscribe, send email to [EMAIL PROTECTED] -
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
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, windows, mac, various embedded platforms, etc. Byte order does not matter either. Perhaps the file was corrupted by whatever utility you used to "move" it from win to Linux? Perhaps \n got converted to \r\n or something. Can you compare the md5 checksum of the file before and after moving it? -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqllite ddb from win to linux
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
"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 matter either. Perhaps the file was corrupted by whatever utility you used to "move" it from win to Linux? Perhaps \n got converted to \r\n or something. Can you compare the md5 checksum of the file before and after moving it? -- 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] -
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
"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
"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?