[rt-users] upgrading from 3.2.2 -> 3.4.0 AND a new host

[Odhiambo Washington]

* Amy Hornberger (Contractor) <amy.hornberger at nrlssc.navy.mil> [20050207 18:04]: wrote:
> 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