= Trac Migration =
[[TracGuideToc]]

 * 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