Mysql撤销slave

CHANGE MASTER TO MASTER_HOST='',MASTER_USER='',MASTER_PASSWORD='';

____________________________________________________________
库房表：

CLOT_REQUISITION_DETAIL_CP
CLOT_REQUISITION_DETAIL_TEMP_CP
CLOT_REQUISITION_FORM_CP
CLOT_REQUISITION_FORM_TEMP_CP
CLOT_REQUISITION_RESUME_CP
DUAL_CP
EXTE_EXTENSION_BASE
PURC_ENTERING_DETAIL
PURC_ENTERING_NOTE
PURC_ENTERING_WAREHOUSE
STOR_ENTERING_DETAIL
STOR_ENTERING_NOTE
STOR_MAINTENANCE
STOR_OUT_DETAIL
STOR_OUT_NOTE
STOR_WASTE


云平台表：

BASE_CODE
BASE_CONFIG
BASE_DEPARTMENT
CLOT_CATEGORY
CLOT_CATEGORY_CLOTHING
CLOT_CLOTHING
CLOT_COLOR
CLOT_COLOR_CLOTHING
CLOT_REQUISITION_DETAIL
CLOT_REQUISITION_DETAIL_TEMP
CLOT_REQUISITION_FORM
CLOT_REQUISITION_FORM_TEMP
CLOT_REQUISITION_RESUME
CLOT_SPECIFICATIONS
CONT_CONTRACT
CONT_TEMPLET_UPLOAD
DUAL
EXHI_ANNOUNCEMENT_COLLECT
EXHI_BACKGROUND_IMAGE
EXHI_COMPANY_COLLECT
EXHI_DETAIL_SET
EXHI_FLASH
EXHI_IMAGES_COLLECT
EXHI_LABEL
EXHI_LABEL_CLOTHING
EXHI_NAVIGATION
EXHI_PROPAGANDA_COLLECT
PERM_AUTHN_MANAGER
PERM_AUTHN_SUPPLIER
PERM_AUTHN_USER
perm_authz_group
perm_authz_group_role
PERM_AUTHZ_RESOURCE
PERM_AUTHZ_ROLE
PERM_AUTHZ_ROLE_RESOURCE
PERM_AUTHZ_USER_GROUP
PERM_AUTHZ_USER_ROLE
PROG_PROGRAM
PURC_LABEL
QRTX_SCHEDULER
QRTX_TASK
QRTX_TASK_TYPE
QRTX_TRIGGER
QRTX_TRIGGER_TYPE
STAT_REQUISITION_COST
STAT_REQUISITION_STATISTICS
STAT_SETTLE_ACCOUNTS
SUPP_CUSTOMER
SUPP_DEVICE
SUPP_EMPLOYEE
SUPP_EVALUATION
SUPP_EVALUATION_SUB
SUPP_MATERIAL
SUPP_PRODUCTS
SUPP_SUPPLIER
SUPP_SUPPLIER_DIRECTORY



_____________________________________________________________

mysql>

change master to master_host='3ae0ae60021d54827305be53aff460d8.tridroip.com', master_user='rep_user', master_password='123456', master_log_file='mysql-bin.000014', master_log_pos=910;

mysql>grant replication slave,file on *.* to rep_user identified by '123456';


-h3ae0ae60021d54827305be53aff460d8.tridroip.com

mysql> create database if not exists clothing default character set utf8;


全库备份

mysql> FLUSH TABLES WITH READ LOCK;

## backup all databases
# mysqldump -uroot -proottoorpassword --all-databases --events > all_0520.sql
# mysqldump -uroot -proottoorpassword clothing --events > clothing.sql

mysql> UNLOCK TABLES;




_____________________________________________________________


作系统版本Centos6.4 cpu：2C 内存：4G 硬盘：50G（系统盘）IP地址192.168.168.54-57用户名root密码Q!W@E#R$


——————————————————————————
10.3.3.133 shiye2 / !QAZ2wsx
10.3.3.132 shiye1 / !QAZ2wsx


ATG 291399995 5580

SY2 251112822 pde837

SY1 251125121 161dkr



——————————————————————————