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