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

[Todd Chapman]

On Mon, Nov 14, 2005 at 12:02:19PM -0500, Kaplan, Andrew H. wrote:
> 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.  

That looks pretty sound. Be sure to budget enought time. All those
MySQL inserts will take a while, depending on database size.

-Todd