Toolpack migration Windows XP 2-3 - Revision history

Ktrueman: /* Install ODBC MySQL connector */

2009-08-12T16:43:51Z

Install ODBC MySQL connector

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

Sylvain Fontaine: /* Toolpack Migration Steps */

2009-08-12T14:04:38Z

Toolpack Migration Steps

Cboulanger at 13:31, 12 August 2009

2009-08-12T13:31:44Z

Luc Morissette: /* Replicate specific databases */

2009-07-14T21:00:06Z

Replicate specific databases

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

Cbilodeau: add mysql connection through host name

2009-05-29T13:48:32Z

add mysql connection through host name

Cbilodeau at 20:22, 19 May 2009

2009-05-19T20:22:02Z

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]].

@@ Line 26: / Line 26: @@
 === 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 ===

@@ Line 5: / Line 5: @@
 === 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 ===

← Older revision		Revision as of 13: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.

@@ Line 67: / Line 67: @@
 * 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'''
@@ Line 75: / Line 80: @@
 * 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.
 === Restart MySQL service ===

@@ 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:
    services.msc
 == 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]].

@@ Line 4: / Line 4: @@
 == Toolpack Migration Steps ==
 === Create new database user ===
@@ Line 98: / Line 102: @@
    tbtoolpack disable 2.2
 == 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]].

@@ Line 64: / Line 64: @@
 * 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.
+** 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.
+** 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'''
@@ Line 72: / Line 72: @@
 * 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.
+** 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.
+** 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 ===

@@ Line 8: / Line 8: @@
 Connect to MySQL and create a new user tbdb with all privilege.
-   mysql -u root
+   mysql -u root -h '[HostName]'
    CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
@@ Line 15: / Line 16: @@
 Example
-   mysql -u root
+   mysql -u root -h winxp32-01
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';