ITrack/Migrating a server

• To access services in the UI, go to Start > Control Panel > Administrative Tools > Services
• To start the MySQL service from the command line: net start mysql or net start mysql5
• To stop the MySQL service from the command line: net stop mysql or net stop mysql5

Note: Before making the switch, warn customer/users that ITrack will not work while the migration is happening.

Current MySQL version to use for Enterprise: 5.0.84

Current MySQL version to use for Pro: 5.1.47

Server Side

Preferred Method

This walk-through requires SQLyog. Alternatively, you can use the MySQL command line utility if your that 1337.

1. Using SQLyog do a dump of the users itrack database
   1. To do this, right click on the database in the left pane and select "Backup database as SQL dump"
   2. Make sure the "Structure and data" radio is selected
   3. Make sure the Include "USE database" statement and Include "CREATE database" statement check-boxes are checked.
   4. Click export
2. Copy the .sql file to the new server
3. Install MySQL on the new server
   1. Import using the .sql script with SQLyog
   2. To import with SQLyog select Tools from the top menu
   3. Choose Restore from SQL dump
4. Check the results, make sure it imported properly

2nd Method

• Note: This method is not recommended and should only be used if you can't use the 1st method.

1. Stop the MySQL service on the "old ITrack server"
2. Create a share on the old ITrack server
3. Copy the ITrack database from C:\Program Files\MySQL\MySQL Server 5.0\data to the share you just created
4. On the new ITrack server, install MySQL server
5. Stop the MySQL service on the new server
6. Use explorer to navigate to the share on the old server
7. Copy the ITrack database directory to the MySQL data directory on the new server
8. Start the MySQL service on the new server.
9. Install SQLYog

Additional Server Changes

1. Create a new user in the mysql database that ITrack will use to connect to the server
2. Change all client machines to be pointed to the new server's name/IP
3. Create an ITrack share on the new server, make sure the "Everyone" group has read and write privileges(for images and attachments).
4. Move the reports, images, attachments directories from the old server to the share on the new server
5. On the old server, set its MySQL service to not start on "automatically"

Client Side

1. Change the "hostname" in all clients host.ini to be the name/IP of the new server.
2. Change the "server" in the ODBC to the name/IP of the new server.
3. Change the reports, images, attachments to point to the share on the new server.
4. Double check with the customer to make sure everything is working properly.