Trac Migration

• Install a Trac enviroment on the destination machine

• On the source machine, dump the sqlite db:

  $ sqlite3 /path/to/trac/db/trac.db ".dump" >> sqlite_trac.sql
  

• Adjust the system table (sqlite_trac.sql) to fix the repository_dir if it's different in the destination machine

   INSERT INTO "system" VALUES('repository_dir', 'svn:fc784ba1-7bb2-4f0b-9d6b-749d55304f83:/var/spool/raid/svn_repo');
  

• Copy the db script to the destination machine

  $ scp sqlite_trac.sql root@192.168.11.125:/root/
  

• Import the script into a db and copy it to the relevant folder

  $ cat sqlite_trac.sql | sqlite3  trac.db
  $ mv trac.db  /var/spool/raid/trac/db/trac.db
  $ chown -R www-data /var/spool/raid/trac/db/trac.db
  

• Migrate any attachments that may exist

  $ scp  /home/trac/attachments/wiki root@192.168.11.125:/var/spool/raid/trac/attachments/
  $ chown -R www-data /var/spool/raid/trac/attachments/
  

• Restart tracd or apache