[rt-users] RE: Moving RT2.0.13 from 1 server to another

[Odhiambo Washington]

* Gororo, Hillary <HGororo at chartercom.com> [20020830 01:20]: wrote:
> Hi Everyone,
> I am new to the list, we just recently purchased a new server and so I am
> preparing to move RT2 from one server to another.  What steps do I need to
> perform?. I understand from scanning through the archives that I will need
> to backup my current RT and load it on the new server.  Do I need a fresh
> install on the new server? and also which directories/files do I need to
> backup, How do I backup these files and how do I load the files onto the new
> server.
> 

From the top of my head (untested)
Step1: Ensure the new system has all the prerequisites for RT.
       I'll setup the Web Server, MySQL server (and even the MTA) and make sure
       they are running well.
  
       Then testing whether RT will run there, I'll do a dummy setup. Just install
       the same version of RT as I have on the old system. If it installs fine, then
       try accessing it (with the root user) and clicking a few things here and there
       just to make sure they are working. If you see much success, then I guess it's
       time to blow it away (rm -rf rt2 directory)

Step2: Setup up your aliases (for the rt e-mail addresses) on the new server. Don't
       Don't fire the MTA up as yet.

Step3: Backup your rt directory (cd /opt && tar -cZf rt2.tgz rt2) and move it to
       the new server (same destination) and extract it. That way you have preserved
       all permissions. You even have all your customizations intact. On the new server
       extract your rt2 to the correct location (tar zxvf rt2.tgz).

Step3: Backup your rt2 database and move it over. (substitute your real values for RT_USER
       and RT_USER_PASS)

       `mysqldump --opt rt2 > backup-rt2.sql`

       Move backup-rt2.sql to the new server.
       Login to the new server as root, create the rt2 database.
       
       `mysqladmin create rt2`

       Setup the correct permissions for your RT_USER; something like
       
       GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX ON rt2.* TO RT_USER at localhost IDENTIFIED by 'RT_USER_PASS';
       flush privileges;

       NB: Please verify the granted perms by login to my sql and doing this query:

       show grants for RT_USER at localhost;
       
       You can then restore the tables and the data back into MySQL with:

       mysql database < backup-file.sql

Step5: If I haven't missed something, then it's time to fire up all applications and see if your RT is
        up and running.



As a side note: Life would be easier if you were to RETIRE the old server. You could just
move the old disk onto the new server or create the new server from the old disk. If both
disks are ATA (say), [This is from FreeBSD's point because I am not familiar with linux],
I'd do a minimal install on the new disk (reflecting similar partitions on old disk), then
mount the new disk into the old machine and write all data from old disk into new disk.
After that, all I've have to do is change a few params on fstab and rc.conf on the new disk,
mount it on the new machine and boot it up.

I create a new partition with  the necessary slices. I mount them on my old
system /mnt/newsystem. 
Write the new using the old rather than copy the old on top of a temporary new.

Off the top of my head I would type the command line:

# dump 0af - / | ( cd /mnt ; restore -rf - )
# dump 0af - /var | ( cd /mnt/var ; restore -rf - )
# dump 0af - /usr | ( cd /mnt/usr ; restore -rf - )
 
5) edit and change your /etc/fstab file to reflect the new changes, save it, move the
   new disk into the new server and reboot!

Donate the old server to charity!

Just my $ 0.02



        cheers
       - wash 
+----------------------------------+-----------------------------------------+
Odhiambo Washington, wash at wananchi.com	. WANANCHI ONLINE LTD (Nairobi, KE)  |
http://ns2.wananchi.com/~wash/		. 1ere Etage, Loita Hse, Loita St.,  |
GSM: (+254) 722 743 223			. # 10286, 00100 NAIROBI             |
+---------------------------------+------------------------------------------+
"Oh My God! They killed init! You Bastards!"  
						 --from a /. post