MASTER_LOG_POS format in python script

61 views
Skip to first unread message

jack...@gmail.com

unread,
Oct 21, 2018, 6:41:36 PM10/21/18
to Python MySQL replication
From line 1 to 6 are right syntax, but line 7 has problem. I need help for the format of MASTER_LOG_POS. Thanks.

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'server1_23332' at line 7
Got error when setting up master
change master to
MASTER_HOST='\''server1'\'',
MASTER_USER='\''mtsrepl'\'',
MASTER_PASSWORD='\''tempxxxx'\'',
MASTER_PORT=53372,
MASTER_LOG_FILE='\''binlog.000008'\'',
MASTER_LOG_POS=33673944 for channel 'server1_23332';

These two format also do not work
MASTER_LOG_POS=33653176 '\''for channel 'server1_23332''\'';

MASTER_LOG_POS='\''33653176 for channel 'server1_23332''\'';
Reply all
Reply to author
Forward
0 new messages