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.7.27 (Do not go higher than this version - Brian)

Current MySQL version to use for Pro: 5.7.x

Current MySQL version to use for AX: 5.6.14

Server Side

Preferred Method

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

1. Use SQLyog create a dump of the users ITrack database
   1. 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
4. Import the .sql dump script with SQLyog
   1. Select Tools from the top menu
   2. Choose Restore from SQL dump
5. 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
   1. (Be careful to make sure you have the correct data. If the customer still has MySQL version 4 installed then it will be in the MySQL directory, but if the customer has MySQL version 5 then the data will be in a sub-directory called MySQL 5.0; otherwise you might delete their up-to-date database and only have the crappy old outdated one to work with)
4. On the new ITrack server, install MySQL server
   1. If you are doing a MySQL reinstall then you may need to uninstall MySQL a few times. It's a little silly, but just because you uninstall the service, the regular files may not have been removed (or vice versa).
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. Create an ITrack share on the new server, make sure the "Everyone" group has read and write privileges(for images and attachments).
3. Move the reports, images, attachments directories from the old server to the share on the new server
4. 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.