Moving RT installation from one machine to another

RT Users
1

Hey All

I have a working RT3 3.0.1 installation all set up with a few queues and
scrips working well.

I want to move this to another faster box and was wondering how best to
do this.

I’ve done a working vanilla install of 3.06 on the new machine. I then
tried shutting MySQL and Apache down, copying the rt3 database from the
old to the new, and restarting the servers but the automagical
migrations of everything didn’t happen.

Any quick suggestions anyone?

Regards,

Irvine

2

I want to move this to another faster box and was wondering how best to
do this.

I’ve done a working vanilla install of 3.06 on the new machine. I then
tried shutting MySQL and Apache down, copying the rt3 database from the
old to the new, and restarting the servers but the automagical
migrations of everything didn’t happen.

If you don’t need the data in the 3.0.6 database, try using mysqldump
on the original database with --opt and --all. Then drop and recreate
the database on the 3.0.6 machine and run the dump output back into
that version of mysql.

At least that’s what I’ve been doing when I’ve totally hosed my
database. You should be doing those dumps as part of your routine
backup procedures.

Michael

Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

3

Michael S. Liebman wrote:

If you don’t need the data in the 3.0.6 database, try using mysqldump
on the original database with --opt and --all. Then drop and recreate
the database on the 3.0.6 machine and run the dump output back into
that version of mysql.

Did that - it worked. I was just being a MySQL newbie.

Cheers and thanks,

Irvine