ITrack/Migrating a server - Revision history

Codeman at 19:42, 9 March 2018

2018-03-09T19:42:34Z

@@ Line 50: / Line 50: @@
 #''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.
 [[Category:ITrack/Support]]

Hheffelbower: HH removed old MySQL version information

2016-09-20T18:45:05Z

HH removed old MySQL version information

← Older revision		Revision as of 13:45, 20 September 2016
Line 5:		Line 5:
	'''Note:''' Before making the switch, warn customer/users that ITrack will not work while the migration is happening.		'''Note:''' Before making the switch, warn customer/users that ITrack will not work while the migration is happening.

	~~{{ITrack Enterprise/MySQL version}}~~

	~~{{ITrack Pro/MySQL version}}~~

	~~{{ITrack AX/MySQL version}}~~

	==Server Side==		==Server Side==

Nenjin: /* Client Side */

2014-12-17T20:22:54Z

Client Side

← Older revision		Revision as of 15:22, 17 December 2014
Line 53:		Line 53:
	#Change the "hostname" in all clients host.ini to be the name/IP of the new server.		#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 "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.		#''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.		#Double check with the customer to make sure everything is working properly.

	[[Category:ITrack/Support]]		[[Category:ITrack/Support]]

Nenjin: /* Additional Server Changes */

2014-12-17T20:22:17Z

Additional Server Changes

← Older revision		Revision as of 15:22, 17 December 2014
Line 47:		Line 47:
	#Move the reports, images, attachments directories from the old server to the share on the new server		#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"		#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==		==Client Side==

Duff: /* Preferred Method */ anal

2010-09-23T07:03:30Z

Preferred Method: anal

← Older revision		Revision as of 02:03, 23 September 2010
Line 13:		Line 13:
	==Server Side==		==Server Side==
	===Preferred Method===		===Preferred Method===
	This walk-through requires [http://en.wikipedia.org/wiki/Sqlyog SQLyog]. Alternatively, you can use the MySQL command line utility if ~~your~~ that 1337.		This walk-through requires [http://en.wikipedia.org/wiki/Sqlyog SQLyog]. Alternatively, you can use the MySQL command line utility if you're that 1337.

	#~~Using~~ SQLyog do a dump of the users ~~itrack~~ database		#Use SQLyog create a dump of the users ITrack database
	##~~To do this, right~~ click on the database in the left pane and select '''"Backup database as SQL dump"'''		##Right click on the database in the left pane and select '''"Backup database as SQL dump"'''
	##Make sure the '''"Structure and data"''' [[ITrack/Control Types#Radio_Button\|radio]] is selected		##Make sure the '''"Structure and data"''' [[ITrack/Control Types#Radio_Button\|radio]] is selected
	##Make sure the '''Include "USE database" statement''' and '''Include "CREATE database" statement''' check-boxes are checked.		##Make sure the '''Include "USE database" statement''' and '''Include "CREATE database" statement''' check-boxes are checked.
Line 22:		Line 22:
	#Copy the .sql file to the new server		#Copy the .sql file to the new server
	#Install MySQL on the new server		#Install MySQL on the new server
	##Import ~~using~~ the .sql script with SQLyog		#Import the .sql dump script with SQLyog
	##~~To import with SQLyog select~~ '''Tools''' from the top menu		##Select '''Tools''' from the top menu
	##Choose '''Restore from SQL dump'''		##Choose '''Restore from SQL dump'''
	#Check the results, make sure it imported properly		#Check the results, make sure it imported properly

Codeman: Added a few helpful tidbits that may come in handy when reinstalling MySQL on the server

2010-08-16T16:25:50Z

Added a few helpful tidbits that may come in handy when reinstalling MySQL on the server

← Older revision		Revision as of 11:25, 16 August 2010
Line 33:		Line 33:
	#Create a share 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		#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		#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		#Stop the MySQL service on the new server
	#Use explorer to navigate to the share on the old server		#Use explorer to navigate to the share on the old server

Duff: Updated to point at MySQL version templates

2010-08-09T19:07:35Z

Updated to point at MySQL version templates

← Older revision		Revision as of 14:07, 9 August 2010
Line 5:		Line 5:
	'''Note:''' Before making the switch, warn customer/users that ITrack will not work while the migration is happening.		'''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: [http://tools.isoftdata.com/mysql-essential-5.0.84-win32.msi '''5.0.84''']~~		{{ITrack Enterprise/MySQL version}}

	~~Current~~ MySQL version ~~to use for Pro: [http:~~/~~/tools.isoftdata.com/mysql-essential-5.1.47-win32.msi '''5.1.47''']~~		{{ITrack Pro/MySQL version}}

			{{ITrack AX/MySQL version}}

	~~Current MySQL version to use for AX: '''5.1.41-3'''~~
	==Server Side==		==Server Side==
	===Preferred Method===		===Preferred Method===

Jmckinstry at 18:39, 7 July 2010

2010-07-07T18:39:07Z

← Older revision		Revision as of 13:39, 7 July 2010
Line 8:		Line 8:

	Current MySQL version to use for Pro: [http://tools.isoftdata.com/mysql-essential-5.1.47-win32.msi '''5.1.47''']		Current MySQL version to use for Pro: [http://tools.isoftdata.com/mysql-essential-5.1.47-win32.msi '''5.1.47''']

			Current MySQL version to use for AX: '''5.1.41-3'''
	==Server Side==		==Server Side==
	===Preferred Method===		===Preferred Method===

Daytonlowell: /* Additional Server Changes */

2010-06-16T23:11:29Z

Additional Server Changes

← Older revision		Revision as of 18:11, 16 June 2010
Line 39:		Line 39:
	===Additional Server Changes===		===Additional Server Changes===
	#Create a new user in the mysql database that ITrack will use to connect to the server		#Create a new user in the mysql database that ITrack will use to connect to the server
	~~#Change all client machines to be pointed to the new server's name/IP~~
	#Create an ITrack share on the new server, make sure the "Everyone" group has read and write privileges(for images and attachments).		#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		#Move the reports, images, attachments directories from the old server to the share on the new server

Daytonlowell at 18:45, 15 June 2010

2010-06-15T18:45:16Z

← Older revision		Revision as of 13:45, 15 June 2010
Line 5:		Line 5:
	'''Note:''' Before making the switch, warn customer/users that ITrack will not work while the migration is happening.		'''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 Enterprise: [http://tools.isoftdata.com/mysql-essential-5.0.84-win32.msi '''5.0.84''']

	Current MySQL version to use for Pro: [http://tools.isoftdata.com/mysql-essential-5.1.47-win32.msi '''5.1.47''']		Current MySQL version to use for Pro: [http://tools.isoftdata.com/mysql-essential-5.1.47-win32.msi '''5.1.47''']