Toolpack migration Debian4 2-3

This page shows the Toolpack 2-4 migration guide for Debian 4.

Toolpack Migration Steps

Create new database user

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 -h '[HostName]'
CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
exit

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

Install ODBC MySQL connector

apt-get install libmyodbc

Configure ODBC driver manager

odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d

Modify MySQL configuration

Configure mysql to support database replication (Will not interfere if your system do not use it). vi /etc/mysql/my.cnf

6.Add 2 new variable in the mysql config file

Comment out the bind-address line (put a '#' in front of the line) Example:

1. bind-address = 127.0.0.1

Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).

Make sure it is in the [mysqld] section

log-bin
server-id=''[UniqueId]''

Example:

1. The following can be used as easy to replay backup logs or for replication. server-id = 1 log_bin = /var/log/mysql/mysql-bin.log

Restart MySQL service service mysql restart

Restart MySQL service

/etc/init.d/mysql restart

Disable Release 2-2 Service

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.