[rt-users] 3.4.2 to 4.x

[Izz Abdullah]

This is the way I upgraded from 3.8 -> 4.0.x.  I think you could pipe the dump without creating the database first, but is seems like I had an issue with MySQL throwing an error back at me saying database rt4 does not exist.  So, to answer your question, yes.  If you have a database already created and you pipe the dump using the mysql -u root -p rt4 < mysqldump.sql command, it will put your dump into the database named rt4.  Then you can go about the database upgrade procedures you have read in the UPGRADE_READMEs.

Hope this helps.

-----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:42 PM
To: rt-users at 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):
> 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
>
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012