Ok, you meant the SQLite version, not the DB schema version You need both "sqlite" (for v2 DB) and "sqlite3" (for v3 DB) command line tools, then use the following commands:
# dump the old V2 database sqlite trac.db .dump > dump.db # rename the old DB mv trac.db trac.db.old # create a new V3 database and load it from the backup file sqlite3 trac.db ".read dump.db" On 9/30/06, Matthew Gibbons <[EMAIL PROTECTED]> wrote: > > Good old 'less'... the trac.db is an SQLite 2.1 format database. The > currently installed version of trac uses SQLite 3 format. How do I > migrate the trac.db to the new format, as the 'trac-admin upgrade' > approach doesn't work? > > Regards, > Matthew > > On 30/09/06, Matthew Gibbons <[EMAIL PROTECTED]> wrote: > > Thanks for the reply. I tried what you suggested, but get the > > following error message: > > > > SQL error: file is encrypted or is not a database > > > > I have tried this with two other trac databases that did not have to > > be restored, and I get the same error. If I initialise a new trac > > environment, I can do as you suggested. > > > > Any thoughts? > > > > Regards > > Matthew > > > > On 30/09/06, Emmanuel Blot <[EMAIL PROTECTED]> wrote: > > > > > > Use the sqlite3 command line tool to open your trac.db file (located > > > in <project>/db), and type: select * from system; > > > > > > You should get a line such as: > > > database_version|19 > > > > > > where the number is the database version. > > > > > > On 9/30/06, Matthew Gibbons <[EMAIL PROTECTED]> wrote: > > > > > > > > Help! > > > > > > > > I have restored a trac environment from backup, but I don't know what > > > > version the trac.db database is. I don't have a record of the trac > > > > version that was being used on the server before it died, but I have > > > > 0.9.3 installed at the moment. > > > > > > > > Regards, > > > > Matthew > > > > > > > > > > > > > > > > > > > > > > -- > > > Manu > > > > > > > > > > > > > > > > > -- Manu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users -~----------~----~----~----~------~----~------~--~---
