Databases Reference
In-Depth Information
Available character sets and collations
The
Charsets
menu tab on the home page opens the
Server
view for the
Charsets
page, which lists the character sets and collations supported by the MySQL server.
The default collation for each character set is shown with a different background color
(using the row-marking color defined in
$cfg['BrowseMarkerColor']
).
Examining binary logs
If MySQL's binary logging is active on our server, the menu in the
Server
view
changes so that a
Binary log
tab appears. This tab gives access to an interface,
through the
SHOW BINLOG EVENTS
command. This command produces the list of
SQL statements that have updated data on our servers. This list could be huge, and
currently phpMyAdmin does not limit its display with a pagination technique.
Hence, we could hit the browser's memory limit, which depends on the particular
browser we are using.
In the following screenshot, we choose the binary log that we want to examine
(unless the server has only one binary log), and the statements are then displayed:
Search WWH ::
Custom Search