Moving Trac project from Windows to unix

49 views
Skip to first unread message

Jani Tiainen

unread,
Nov 16, 2007, 1:03:59 AM11/16/07
to trac-...@googlegroups.com
Howdy,

I'm moving loads of Trac projects from Windows box to Linux box.

What would be best option to make transfer? Setup projects as blank in
Linux and copy only DB? Or copy whole projects and update paths accordingly?

--

Jani Tiainen

Emmanuel Blot

unread,
Nov 16, 2007, 6:24:09 AM11/16/07
to trac-...@googlegroups.com
> What would be best option to make transfer? Setup projects as blank in
> Linux and copy only DB? Or copy whole projects and update paths accordingly?

Well, the safest way is to use portable file format between two
different hosts (if the HW architecture is different, you might get
real issues if you simply copy binary files)

Use 'sqlite3' to dump and re-read <project>/db/trac.db files, and
svnadmin for the Subversion repositories.
Other files can be copied as is, although I would recommend you run
'dos2unix' or the eq. command on <project>/conf/trac.ini files to
convert CRLF end-of-lines into LF end-of-lines.

HTH,
Manu

Jani Tiainen

unread,
Nov 16, 2007, 7:17:58 AM11/16/07
to trac-...@googlegroups.com
Emmanuel Blot kirjoitti:

Well I meant "dumping" in some protable format.

But still, would anything bad happen if I recreate my trac projects and
just replace db with dump data?

--

Jani Tiainen

Jonas Borgström

unread,
Nov 18, 2007, 9:43:08 AM11/18/07
to trac-...@googlegroups.com
Jani Tiainen wrote:
>
> Emmanuel Blot kirjoitti:
>>> What would be best option to make transfer? Setup projects as blank in
>>> Linux and copy only DB? Or copy whole projects and update paths accordingly?
>>
>> Well, the safest way is to use portable file format between two
>> different hosts (if the HW architecture is different, you might get
>> real issues if you simply copy binary files)
>>
>> Use 'sqlite3' to dump and re-read <project>/db/trac.db files, and
>> svnadmin for the Subversion repositories.
>> Other files can be copied as is, although I would recommend you run
>> 'dos2unix' or the eq. command on <project>/conf/trac.ini files to
>> convert CRLF end-of-lines into LF end-of-lines.
>>

Sqlite dump/load should only be necessary when moving from sqlite2 to
sqlite3. The sqlite file format is platform independent.

>
> Well I meant "dumping" in some protable format.
>
> But still, would anything bad happen if I recreate my trac projects and
> just replace db with dump data?

Simply copying the env to the new system should work. One possible issue
might be file attachments when an environment is moved from a case
insensitive filesystem to a case sensitive filesystem. But iirc NTFS is
case preserving so this might not be an issue after all...

Cheers,
Jonas

Jani Tiainen

unread,
Nov 19, 2007, 12:48:01 AM11/19/07
to trac-...@googlegroups.com
Jonas Borgström kirjoitti:

Yep, NTFS is (by default, can be changed) case insensitive, case preserving.

So I'm pretty much good to go.

Altough still bothers me: is it better to setup projects before copying
data (creating new ini files etc?) or doesn't matter?

--

Jani Tiainen

Jonas Borgström

unread,
Nov 19, 2007, 1:39:34 PM11/19/07
to trac-...@googlegroups.com
Jani Tiainen wrote:
> Yep, NTFS is (by default, can be changed) case insensitive, case preserving.
>
> So I'm pretty much good to go.
>
> Altough still bothers me: is it better to setup projects before copying
> data (creating new ini files etc?) or doesn't matter?
>

It's probably easiest to simply copy the env to the new system and
update trac.ini with the new repository location.

Cheers,
Jonas

Reply all
Reply to author
Forward
0 new messages