[rt-users] 3.4.2 to 4.x

[Ruslan Zakirov]

On Sat, Dec 24, 2011 at 00:42, Jeff Blaine <jblaine at kickflop.net> wrote:
> 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?

mysqldump --opt xxx > xxx.dump.sql

This command doesn't add create database or other instructions to
select database. You specify database to restore dump into when you
run `mysql xxx < xxx.dump.sql`.

Note that you're using RT 3.4 on mysql 4.1 and newer, then you should
use binary charset during dumping and don't forget to upgrade mysql
schema. It's special step described in the documentation.

>
>
>> -----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



-- 
Best regards, Ruslan.