| 28 | |
| 29 | |
| 30 | == Upgrading SQLite from 2.x to 3.x == |
| 31 | The following information is copied from http://dev.ctor.org/pkcs1/wiki/TracUpgrade |
| 32 | |
| 33 | The database formats used by SQLite 2.x and sqlite 3.x are incompatible. If you upgrade your SQLite version (this can also happen implicitly if you upgrade from PySQLite 1.0.x to 1.1.x or 2.x), then you must convert your database. |
| 34 | |
| 35 | To do this, install both SQLite 2.8 and SQLite 3.x (they have different filenames so can coexist in the same directory). Then use the following commands (Windows): |
| 36 | {{{ |
| 37 | $ mv trac.db trac2.db |
| 38 | $ sqlite trac2.db .dump | sqlite3 trac.db |
| 39 | }}} |
| 40 | |
| 41 | Then when you're happy with the conversion and tested everything you can delete the trac2.db file. |
| 42 | |
| 43 | For more information see http://www.sqlite.org/version3.html |