Upgrading from 3.2.2 -> 3.4.0 AND a new host

I’ve been using RT 3.2.2 for about 4 months on a FedoraCore 2 box and
have recently realized that the hardware (500 Mhz Pentium, 256 MB RAM)
is not sufficient. I found another box (dual 1.2 Ghz cpus and 1 GB RAM)
and have installed RT 3.4.0 on Fedora Core 3. The install seemed to go
well. Now I’m ready to move the mysql database from old machine to new
machine. Is it as simple as export/import or can I simply drop the old
database file in place on the new machine?

Thanks for your help.

amy

From what I’ve read as long as your accounts/password/permissions are the
same from a mysql perspective you can just copy over the datafiles.

Rick-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Amy
Hornberger (Contractor)
Sent: Monday, February 07, 2005 9:45 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] upgrading from 3.2.2 -> 3.4.0 AND a new host

I’ve been using RT 3.2.2 for about 4 months on a FedoraCore 2 box and have
recently realized that the hardware (500 Mhz Pentium, 256 MB RAM) is not
sufficient. I found another box (dual 1.2 Ghz cpus and 1 GB RAM) and have
installed RT 3.4.0 on Fedora Core 3. The install seemed to go well. Now I’m
ready to move the mysql database from old machine to new machine. Is it as
simple as export/import or can I simply drop the old database file in place
on the new machine?

Thanks for your help.

amy

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

I’ve been using RT 3.2.2 for about 4 months on a FedoraCore 2 box and
have recently realized that the hardware (500 Mhz Pentium, 256 MB RAM)
is not sufficient. I found another box (dual 1.2 Ghz cpus and 1 GB RAM)
and have installed RT 3.4.0 on Fedora Core 3. The install seemed to go
well. Now I’m ready to move the mysql database from old machine to new
machine. Is it as simple as export/import or can I simply drop the old
database file in place on the new machine?

You are upgrading between versions! I recommend you follow the UPGRADE
procedure like a bible, then migrate your database to the new machine
the MySQL-way. I believe it goes like:

  1. Stop RT

  2. mysqldump --opt rt3 > rt3.sql

  3. move this file over to new box

  4. mysqladmin create rt3

  5. mysql rt3 < rt3.sql

  6. Configure your RT instance as needed.

     cheers
    - wash 
    

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash at wananchi _ dot _ com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post