Changes between Version 5 and Version 6 of TracUpgrade

Timestamp:

Feb 9, 2005, 11:23:25 PM (19 years ago)

Author:

Walter Nicholls

Comment:

Add note about upgrading sqlite database from 2.x to 3.x

TracUpgrade

@@ -10 +10 @@
 The database schema was changed between 0.7.x and 0.8. Existing environments
 must be upgraded before they can be used with Trac 0.8.
+
 
 The following command will automatically perform the upgrade:
@@ -33 +34 @@
 }}}
 
+== Upgrading sqlite from 2.x to 3.x ==
+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 pysqlite) then you must convert your database. 
+
+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):
+{{{
+ c:\...> ren trac.db trac2.db
+ c:\...> sqlite trac2.db .dump | sqlite3 trac.db
+}}}
+(Unix/Linux would be similar but with mv instead of ren)
+
+Then when you're happy with the conversion and tested everything ''(of course!)'' you can delete the trac2.db file.
+
+For more information see http://www.sqlite.org/version3.html
+
+
+
 -----
 See also: TracGuide, TracInstall