Transferring Database from one machine to another

RT Users
1

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 -p -h rt3 <

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
-p -h rt3 >

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.

2

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 -p -h rt3 <

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
-p -h rt3 >

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