Incorrect replication coordinates in backup-*_mysql.pos
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mylvmbackup |
New
|
Undecided
|
Unassigned |
Bug Description
Hello,
i've taken a snapshot backup from a MySQL-Slave (5.1.30) with mylvmbackup.
After restoring the backup on another server and before starting the replication I verified the replication coordinates and i think there are incorrect in the backup-*_mysql.pos - file.
mysql> show slave status\G
*******
Replicate
Replicate_
Master_
backup-
Master:
Master:Position=420
Master:
Master:
Slave:Slave_
Slave:Master_
Slave:Master_
Slave:Master_
Slave:Connect_
Slave:Master_
Slave:Read_
Slave:Relay_
Slave:Relay_
Slave:Relay_
Slave:Slave_
Slave:Slave_
Slave:Replicate
Slave:Replicate
Slave:Replicate
Slave:Replicate
Slave:Replicate
Slave:Replicate
Slave:Last_Errno=0
Slave:Last_Error=
Slave:Skip_
Slave:Exec_
Slave:Relay_
Slave:Until_
Slave:Until_
Slave:Until_
Slave:Master_
Slave:Master_
Slave:Master_
Slave:Master_
Slave:Master_
Slave:Master_
Slave:Seconds_
Slave:Master_
Slave:Last_
Slave:Last_
Slave:Last_
Slave:Last_
I think
incorrect:
Slave:Read_
correct::
Slave:Read_
Ok, you don't need this variables for setting up replication (Relay_
Björn