Toolpack migration Windows XP 2-3 - Revision history

Ktrueman: /* Install ODBC MySQL connector */

2009-08-12T16:43:51Z

Install ODBC MySQL connector

← Older revision		Revision as of 12:43, 12 August 2009
Line 26:		Line 26:
	=== Install ODBC MySQL connector ===		=== Install ODBC MySQL connector ===

	Install ~~MyODBC, it can be download from the following location:~~ http://dev.mysql.com/downloads/connector/odbc/3.51.html Use the Windows MSI installer to make sure the connector properly registers to the ODBC manager.		Install [http://dev.mysql.com/downloads/connector/odbc/3.51.html MyODBC] for MySQL. Use the Windows MSI installer to make sure the connector properly registers with the ODBC manager.


	=== Enable MySQL database replication ===		=== Enable MySQL database replication ===

Ktrueman: /* Migrating from MSVC6 installation to MSVC8 */ cleaned up language and links

2009-08-12T16:42:20Z

Migrating from MSVC6 installation to MSVC8: cleaned up language and links

← Older revision		Revision as of 12:42, 12 August 2009
Line 5:		Line 5:

	=== Migrating from MSVC6 installation to MSVC8 ===		=== Migrating from MSVC6 installation to MSVC8 ===
	If you ~~plan migrating~~ from MSVC6 to MSVC8 (ie TBToolPack-x.y.zz-<b>msvc8</b>-Setup.exe, instead of TBToolPack-x.y.zz-<b>msvc6</b>-Setup.exe) ~~then~~ you need to install ~~the following:~~		If you intend to migrate from MSVC6 to MSVC8 (ie TBToolPack-x.y.zz-<b>msvc8</b>-Setup.exe, instead of TBToolPack-x.y.zz-<b>msvc6</b>-Setup.exe), you will first need to install [http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)].

	http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en

	=== Create new database user ===		=== Create new database user ===

Sylvain Fontaine: /* Toolpack Migration Steps */

2009-08-12T14:04:38Z

Toolpack Migration Steps

← Older revision		Revision as of 10:04, 12 August 2009
Line 4:		Line 4:
	== Toolpack Migration Steps ==		== Toolpack Migration Steps ==

			=== Migrating from MSVC6 installation to MSVC8 ===
			If you plan migrating from MSVC6 to MSVC8 (ie TBToolPack-x.y.zz-<b>msvc8</b>-Setup.exe, instead of TBToolPack-x.y.zz-<b>msvc6</b>-Setup.exe) then you need to install the following:

			http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en

	=== Create new database user ===		=== Create new database user ===
Line 98:		Line 102:

	tbtoolpack disable 2.2		tbtoolpack disable 2.2


	== Toolpack System installation ==		== Toolpack System installation ==

	Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].		Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].

Cboulanger at 13:31, 12 August 2009

2009-08-12T13:31:44Z

← Older revision		Revision as of 09:31, 12 August 2009
Line 24:		Line 24:
	=== Install ODBC MySQL connector ===		=== Install ODBC MySQL connector ===

	Install MyODBC, it can be download from the following location: http://dev.mysql.com/downloads/connector/odbc/3.51.html		Install MyODBC, it can be download from the following location: http://dev.mysql.com/downloads/connector/odbc/3.51.html Use the Windows MSI installer to make sure the connector properly registers to the ODBC manager.

Luc Morissette: /* Replicate specific databases */

2009-07-14T21:00:06Z

Replicate specific databases

← Older revision		Revision as of 17:00, 14 July 2009
Line 67:		Line 67:
	* If you want to specify databases that won't be logged		* If you want to specify databases that won't be logged
	** Add the variable ''binlog-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''binlog-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.

			Final my.ini configuration for Master side should look like this:
			log-bin
			server-id=101
			binlog-do-db=toolpack_0

	'''Slave server side'''		'''Slave server side'''
Line 75:		Line 80:
	* If you want to specify databases that won't be replicated		* If you want to specify databases that won't be replicated
	** Add the variable ''replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.

			Final my.ini configuration for Slave server side should look like this:
			log-bin
			server-id=101
			replicate-do-db=toolpack_0

	=== Restart MySQL service ===		=== Restart MySQL service ===

Luc Morissette: /* Replicate specific databases */

2009-07-14T20:57:03Z

Replicate specific databases

Cbilodeau: add disable 2.2 system

2009-06-05T12:52:13Z

add disable 2.2 system

← Older revision		Revision as of 08:52, 5 June 2009
Line 84:		Line 84:
	Warning: You may have a different service name in your system (ex. MySQL, MySQL50, etc.). To open the service control panel, run:		Warning: You may have a different service name in your system (ex. MySQL, MySQL50, etc.). To open the service control panel, run:
	services.msc		services.msc


			=== Disable Release 2-2 Service ===

			tbtoolpack disable 2.2


	== Toolpack System installation ==		== Toolpack System installation ==

	Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].		Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].

Cbilodeau: add mysql connection through host name

2009-05-29T13:48:32Z

add mysql connection through host name

← Older revision		Revision as of 09:48, 29 May 2009
Line 8:		Line 8:

	Connect to MySQL and create a new user tbdb with all privilege.		Connect to MySQL and create a new user tbdb with all privilege.
			If you are unable to connect, use an IP Address instead of the ''[HostName]''.

	mysql -u root		mysql -u root -h '[HostName]'
	CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';		CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
	GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';		GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
Line 15:		Line 16:

	Example		Example
	mysql -u root		mysql -u root -h winxp32-01
	CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';		CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
	GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';		GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';

Cbilodeau at 20:22, 19 May 2009

2009-05-19T20:22:02Z

← Older revision		Revision as of 16:22, 19 May 2009
Line 75:		Line 75:
	** Add the variable ''--replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''--replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.


			=== Restart MySQL service ===

			net stop MySQL51
			net start MySQL51

			Warning: You may have a different service name in your system (ex. MySQL, MySQL50, etc.). To open the service control panel, run:
			services.msc

	== Toolpack System installation ==		== Toolpack System installation ==

	Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].		Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].

Cbilodeau: Creation

2009-05-19T19:42:03Z

Creation

New page

This page shows the Toolpack 2-3 migration guide for Windows XP.

== Toolpack Migration Steps ==

=== Create new database user ===

Connect to MySQL and create a new user tbdb with all privilege.

mysql -u root
CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
exit

Example
mysql -u root
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
exit

=== Install ODBC MySQL connector ===

Install MyODBC, it can be download from the following location: http://dev.mysql.com/downloads/connector/odbc/3.51.html

=== Enable MySQL database replication ===
==== Enable binlog ====
Binlog file is required for a master to log every statements done on databases and for slaves to be able to read it.

'''Manually'''
* Go to your MySQL server directory
* Edit the configuration file (usually my.ini)
* Add the variable ''log-bin''. If you want to specify a filename you have to add ''=filename''. Otherwise it will create the file with the default name

'''Using MySQL Administrator tool'''
* Open the MySQL Administrator tool and login
* Go to ''Startup variables'' and ''Log files'' tab
* Activate ''Binary Logfile name''. If you don't specify a filename, it will create the file with the default name

==== Set server id ====
Each MySQL server must have unique server id to be able to communicate. If a slave server has the same server id of a master, replication won't work.

'''Manually'''
* Go to your MySQL server directory
* Edit the configuration file (usually my.ini)
* Add the variable ''server-id='' and specify a unique id for it (except 0)

'''Using MySQL Administrator tool'''
* Open the MySQL Administrator tool and login
* Go to ''Startup variables'' and ''Replication'' tab
* Activate ''Server Id'' and specify a unique id for it (except 0)

==== Replicate specific databases ====

You can configure the replication of one or more specific databases instead of all by default. You can do it on master server side or slave server side.

'''Master server side'''
* Go to your MySQL server directory
* Edit the configuration file (usually my.ini)
* If you want to specify databases to be logged
** Add the variable ''--binlog-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.
* If you want to specify databases that won't be logged
** Add the variable ''--binlog-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.

'''Slave server side'''
* Go to your MySQL server directory
* Edit the configuration file (usually my.ini)
* If you want to specify databases to replicate
** Add the variable ''--replicate-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.
* If you want to specify databases that won't be replicated
** Add the variable ''--replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.

== Toolpack System installation ==

Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].

← Older revision		Revision as of 16:57, 14 July 2009
Line 64:		Line 64:
	* Edit the configuration file (usually my.ini)		* Edit the configuration file (usually my.ini)
	* If you want to specify databases to be logged		* If you want to specify databases to be logged
	** Add the variable ''--binlog-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''binlog-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.
	* If you want to specify databases that won't be logged		* If you want to specify databases that won't be logged
	** Add the variable ''--binlog-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''binlog-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be logged in the binlog. You can add as many databases as you want by adding the same variable with a different database name.

	'''Slave server side'''		'''Slave server side'''
Line 72:		Line 72:
	* Edit the configuration file (usually my.ini)		* Edit the configuration file (usually my.ini)
	* If you want to specify databases to replicate		* If you want to specify databases to replicate
	** Add the variable ''--replicate-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''replicate-do-db=db_name''. The value of ''db_name'' is the name of the database you want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.
	* If you want to specify databases that won't be replicated		* If you want to specify databases that won't be replicated
	** Add the variable ''--replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.		** Add the variable ''replicate-ignore-db=db_name''. The value of ''db_name'' is the name of the database you don't want to be replicated. You can add as many databases as you want by adding the same variable with a different database name.


	=== Restart MySQL service ===		=== Restart MySQL service ===