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] -----------------------------------------------------------------------------