[rt-users] Transferring Database from one machine to another

[Kaplan, Andrew H.]

Hi there --

I am going through the motions of setting up a newer system to replace our
current RT 3.4.4 server. The new server will run the same version of the
application. The database that I am using is MySQL 4.1.11. 

I am backing up the database every night using the Webmin application's backup
utility. This utility saves the database to a flat file. This file, in turn, is
backed up to tape using a third-party application.

My plan was to build the new system with a configuration that mirrors that of
the current server. I would then restore the flat file to a directory, and then
run the following command to import the information to the database:

mysql -u <rt user> -p<rt password> -h <rt hostname> rt3 < <flatfile name>

As a backup to the above plan, prior to bringing down the server, I was planning
on doing a dump using the following command:

mysqldump --opt --add-drop-table --single-transaction -u <rt user>
-p<rt password> -h <databasehost> rt3 > <flatfile name>

This file would then be backed up similar to how I have been doing it.

Is this the correct procedure to use, or am I missing a step? Thanks.