How to create a mysql image database in linux _ PHP Tutorial

Teaches you how to create a mysql image database in linux. MySQL version: 4.1 environment introduction: master database 192.168.0.205 from the database 192.168.0.2061, the master database to create etcmy. cnf, modify the key value in [mysqld] to increase the server-id1log-binbinlog_name2, master database MySQLVersion: 4.1

Environment introduction: master database 192.168.0.205 slave database 192.168.0.206

1. create/etc/my. cnf in the master database and modify the key value in [mysqld] to increase

Server-id = 1

Log-bin = binlog_name

2. add users to the master database to read logs from the master database.

Grant replication slave, reload, super on *. *
'Slave '@ '192. 168.0.206 'identified by '20140901'

3. connect the slave database to the master database for testing.

/Opt/mysql/bin/mysql-u slave-p-h 192.168.0.205

4. stop the slave database, modify the slave database/etc/my. cnf, and add the following options:

Http://www.bkjia.com/PHPjc/631009.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/631009.htmlTechArticleMySQL version: 4.1 environment introduction: master database 192.168.0.205 from the database 192.168.0.206 1, master database creation/etc/my. cnf: change the key value in [mysqld] to add server-id = 1 log-bin = binlog_name 2, master database...