Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Dustin Berube
On Wed, Dec 28, 2011 at 9:50 AM, Darin Perusich wrote: > > I have a bunch of notes I can share which might be helpful, I ran into a > few issues performing the update because of AssetTracker. Ping me > off-list and I'll share them. > > Darin, I'd be interested in seeing any notes you would be wil

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread drey111
rom: Jeff Blaine Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 28 Dec 2011 12:27:47 To: Subject: Re: [rt-users] 3.4.2 to 4.x On 12/28/2011 9:50 AM, Darin Perusich wrote: > Hi Jeff, > > I did an upgrade from mysql to postgres a few month back and it went > very smoothly. I

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Jeff Blaine
On 12/28/2011 9:50 AM, Darin Perusich wrote: Hi Jeff, I did an upgrade from mysql to postgres a few month back and it went very smoothly. I used the rt-mysql2pg script available at http://wiki-archive.bestpractical.com/view/rt-mysql2pg to convert the data which performed seamlessly. Hi Darin,

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Darin Perusich
Hi Jeff, I did an upgrade from mysql to postgres a few month back and it went very smoothly. I used the rt-mysql2pg script available at http://wiki-archive.bestpractical.com/view/rt-mysql2pg to convert the data which performed seamlessly. I have a bunch of notes I can share which might be helpful

Re: [rt-users] 3.4.2 to 4.x

2011-12-28 Thread Jeff Blaine
The RT 3.4 to RT 4.0.4 upgrade went fine. Now with our data in MySQL 5.1.x, instead of the old MySQL 4.1, and our new instance not in production yet, we want to migrate to PostgreSQL 8.4.9, largely in order to get performant full-text searching without doing something hackish with MySQL and Sphin

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Ruslan Zakirov
oun...@lists.bestpractical.com >> [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine >> Sent: Friday, December 23, 2011 2:00 PM >> To: rt-users@lists.bestpractical.com >> Subject: Re: [rt-users] 3.4.2 to 4.x >> >> I've read and re-read doc

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Izz Abdullah
s-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:42 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x On 12/23/2011 3:03 PM, Izz Abdullah wrote: > Just (within MySql): > cre

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Jeff Blaine
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jeff Blaine Sent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Izz Abdullah
ent: Friday, December 23, 2011 2:00 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.4.2 to 4.x I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box.

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Jeff Blaine
I've read and re-read docs/UPGRADING*. Things are going quite smoothly so far, as this is a pretty stock old install of 3.4.2 heading to 4.0.4 on a totally different box. Question: Importing the old MySQL 'rt3' database as 'rt4' How? Edit the dump file? Thanks for any further help! On 12/22

Re: [rt-users] 3.4.2 to 4.x

2011-12-23 Thread Root Kev
I recently went through upgrading/migrating to a new server and setting up an upgrade from a 3.4.5 to 4.0.2. Let me know if you want the steps that I went through to get it working... Kevin On Thu, Dec 22, 2011 at 4:55 PM, Thomas Sibley wrote: > On 12/22/2011 03:45 PM, Jeff Blaine wrote: > > Bef

Re: [rt-users] 3.4.2 to 4.x

2011-12-22 Thread Thomas Sibley
On 12/22/2011 03:45 PM, Jeff Blaine wrote: > Before I waste a bunch of time, is there any chance this > is likely to work? > > 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') > 2. Stand up new server with RT 4.x and modern MySQL > 3. Import old data Not with just those steps, but yes, o

[rt-users] 3.4.2 to 4.x

2011-12-22 Thread Jeff Blaine
Before I waste a bunch of time, is there any chance this is likely to work? 1. Dump all RT 3.4.2 data from MySQL 4.1 (database 'rt3') 2. Stand up new server with RT 4.x and modern MySQL 3. Import old data RT Training Sessions (http://bestpractical.com/services/training.html) * Boston Ma