ITrack/Migrating a server
From ISoft Wiki
< ITrack
Jump to navigationJump to search
- 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.
- Use SQLyog create a dump of the users ITrack database
- Right click on the database in the left pane and select "Backup database as SQL dump"
- Make sure the "Structure and data" radio is selected
- Make sure the Include "USE database" statement and Include "CREATE database" statement check-boxes are checked.
- Click export
- Copy the .sql file to the new server
- Install MySQL on the new server
- Import the .sql dump script with SQLyog
- Select Tools from the top menu
- Choose Restore from SQL dump
- 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.
- Stop the MySQL service on the "old ITrack server"
- Create a share on the old ITrack server
- Copy the ITrack database from C:\Program Files\MySQL\MySQL Server 5.0\data to the share you just created
- (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)
- On the new ITrack server, install MySQL server
- 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).
- Stop the MySQL service on the new server
- Use explorer to navigate to the share on the old server
- Copy the ITrack database directory to the MySQL data directory on the new server
- Start the MySQL service on the new server.
- Install SQLYog
Additional Server Changes
- Create a new user in the mysql database that ITrack will use to connect to the server
- Create an ITrack share on the new server, make sure the "Everyone" group has read and write privileges(for images and attachments).
- Move the reports, images, attachments directories from the old server to the share on the new server
- On the old server, set its MySQL service to not start on "automatically"
- Set the Replikwando Service on the old server to "Disabled" and make sure it's not still running.
- Disable the Windows Scheduled Task for Image Synch.
Client Side
- Change the "hostname" in all clients host.ini to be the name/IP of the new server.
- Change the "server" in the ODBC to the name/IP of the new server.
- Change the reports, images, attachments to point to the share on the new server. (This should no longer be necessary after database images.)
- Double check with the customer to make sure everything is working properly.