[rt-users] 3.4.2 to 4.x

[Jeff Blaine]

On 12/23/2011 3:03 PM, Izz Abdullah wrote:
> Just (within MySql):
> create database rt4;
> Then, from the command line, using the dump from your current mysql server,
> mysql -u<username>  -p rt4<  <name_of_sql_dump.sql>

Thanks.  That will override the 'CREATE DATABASE' in
the rt3 dump file?

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jeff Blaine
> Sent: Friday, December 23, 2011 2:00 PM
> To: rt-users at 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.
>
> Question:
>
> Importing the old MySQL 'rt3' database as 'rt4'
>
> How?  Edit the dump file?
>
> Thanks for any further help!
>
> On 12/22/2011 4:55 PM, Thomas Sibley wrote:
>> 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, of course you can upgrade from
>> 3.4.2 to 4.0.4.  Carefully read and follow the instructions in the
>> UPGRADING.mysql, UPGRADING-3.4, UPGRADING-3.6, UPGRADING-3.8, and
>> UPGRADING-4.0 documentation.
>>
>> You have a large upgrade ahead of you, but it's well documented and
>> fairly straightforward.
>> http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html is a
>> gentle introduction, but it does not try to cover all of the
>> individual steps you'll need to take, just the general process.
>>
>> Thomas
>> --------
>> RT Training Sessions (http://bestpractical.com/services/training.html)
>> * Boston  March 5&   6, 2012
>>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5&  6, 2012
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5&  6, 2012
>