Home » Forums » Public Forums » Archived Forums » JumpBox for Trac/Subversion Discussion

Importing existing trac/upgrading sqlite

Submitted by ismangil on Fri, 02/01/2008 - 7:20am

Hi,

As a registered user, I am trying to hotcopy my existing trac to trac JumpBox.

After copying, running trac upgrade I am receiving the error: "command failure: unsupported file format".

I suppose this is because my existing trac uses sqlite 3.4.0 and JB is different.

Any suggestions?

‹ Help: SVN email notification WikiPublicPatch and WikiPrivatePatch ›
»

Importing existing trac/upgrading sqlite

Submitted by godber on Fri, 02/01/2008 - 1:32pm.

Yeah, a hotcopy won't work if the sqlite version version changes. You will have to dump the sqlite database on your old one and import it into the JumpBox ... somewhat like shown here: http://trac.edgewall.org/wiki/TracMigrate

You may have to run trac-admin on the JumpBox once you have placed the SQLite db in the correct place and run upgrade and wiki-upgrade and resync.

So assuming you have made a sqlite dump (sqlite.sql) of your old trac, the things you need to do on the jumpbox are roughly this (this of course overwrites anything you have done on the jumpbox you perform this on):

cat sqlite_trac.sql | sqlite3  trac.db
mv trac.db /var/data/projects/trac/project/db/trac.db
trac-admin /var/data/projects/trac/project
upgrade
wiki upgrade
resync

I had the same issue when I imported from our legacy trac to a JumpBox. Plugins and svn hooks may need to be addressed as well. Also, if you are moving subversion, hotcopy probably won't work for you. You will have to use dump and load instead. Good luck.

Austin

»