62 lines
1.4 KiB
PHP
62 lines
1.4 KiB
PHP
# ==== Purpose ====
|
|
#
|
|
# Retrieves the server id of a certain event in the binlog.
|
|
#
|
|
# ==== Usage ====
|
|
#
|
|
# [--let $event_number= <binlog ordinal of the event> ]
|
|
# [--let $binlog_name= <binlog name> ]
|
|
# [--let $debug= 1]
|
|
# --source include/show_binlog_events_server_id.inc
|
|
#
|
|
# Parameters:
|
|
# $event_number
|
|
# The ordinal in the list of events returned by SHOW BINLOG EVENTS
|
|
# It is 1-based. Default value is 1.
|
|
#
|
|
# $binlog_name
|
|
# The name of the binlog. Default is the one presented by
|
|
# SHOW BINLOG EVENTS.
|
|
#
|
|
# $debug
|
|
# Enables debug information. Default is not enabled.
|
|
#
|
|
# Return Value
|
|
# $event_server_id
|
|
# The value from the server id of the requested event.
|
|
#
|
|
# Example:
|
|
#
|
|
# --let $event_number= 2
|
|
# --let $binlog_name= master-bin.000002
|
|
# --let $debug= 1
|
|
# --source include/show_binlog_events_server_id.inc
|
|
#
|
|
# --echo $event_server_id
|
|
#
|
|
|
|
--let $include_filename= show_binlog_events_server_id.inc
|
|
--source include/begin_include_file.inc
|
|
|
|
--let $_event_number= 1
|
|
if($event_number)
|
|
{
|
|
--let $_event_number= $event_number;
|
|
}
|
|
|
|
--let $_query= SHOW BINLOG EVENTS
|
|
if($binlog_name)
|
|
{
|
|
--let $_query= $_query IN '$binlog_name'
|
|
}
|
|
|
|
--let $event_server_id= query_get_value($_query, Server_id, $_event_number)
|
|
|
|
if($debug)
|
|
{
|
|
--echo Server Id for Event is $event_server_id
|
|
}
|
|
|
|
--let $include_filename= show_binlog_events_server_id.inc
|
|
--source include/end_include_file.inc
|