?????????????????????????(??????)????????????????

????B. ?????????????????????

mysql > SHOW MASTER STATUS;

+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual??mysql |
+---------------+----------+--------------+------------------+

????????File?????????????????Position??????????????????????????????

????5. ???mysqldump????zencart????????????????

??????????????????????????????????????????????4?????????????????????????￡???????session????????????????????У?

shell> mysqldump database_name1 --lock-all-tables > dbdump_database_name1.db

???????У?database_name1??????????zencart??????????????????ж??zencart????????????????????mysqldump??????

????????????? dbdump_database_name1.db ???????????????

????????????????4??????????????????

mysql> UNLOCK TABLES;

????6. ?????????????????????

??????????????????5??????????????????zencart???????????

????A. ???????????????????? --skip-slave-start??

shell> /etc /init.d/mysqld stop
shell> /etc /init.d/mysqld start --skip-slave-start

????B. ???????????

shell> mysql < dbdump_database_name1.db

????C. ?????????????????

mysql> CHANGE MASTER TO
->     MASTER_HOST='master_host_name'??
->     MASTER_USER='replication_user_name'??
->     MASTER_PASSWORD='replication_password'??
->     MASTER_LOG_FILE='recorded_log_file_name'??
->     MASTER_LOG_POS=recorded_log_position;

????D. ??????????

mysql> START SLAVE;

???????????????????з????????????MySQL????3306??????????????????IP??????????