Lawrence Sorrillo wrote:
Are the values of these variables all accessible via the command: "show
variables"?
>
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the value
which determines where in the binary logs you
Are the values of these variables all accessible via the command: "show
variables"?
Josh Miller wrote:
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be a
MAS! wrote:
I'd like to use that backup to setup a new slave (from the same (and
unique) master); the problem is I don't know how set-up this new slave,
since I don't know the right master binary-log num and position; in the
backup I have the "slave's" binary-log/pos and not the master ones :(
