 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
MySQL: Setting the binary log file
|
Setting the binary log file. This can be configured in /etc/my.cnf
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin = /usr/local/var/mysqlLOGb.log
log = /usr/local/var/mysqlLOG.log
or for the default hostname just log-bin
[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin
IMPORTANT: The default my.cnf has a "log-bin" entry. Make sure it is not listed twice.
It's also possible to set the text log file. Note both "log-bin" and "log" are set here:
[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin = /usr/local/var/mysqlLOGb.log
log = /usr/local/var/mysqlLOG.log
Note, (see TIP 24:) the binary log file works with the "show binlog events command" and shows, updates,
creates, deletes, and drops, but no select statements. In contrast, the text log-file "/usr/local/var/mysqlLOG.log"
shows the user, and the select statement, all of the above, but it's in a text file. I believe the text
format is going away with version 5.0.
The following command "DOES NOT" give information about these log files:
mysql> show logs;
This is only for Berkeley DB type databases before commit on this type of table. It's not what you want!
|
About the author of this programming example or tutorial:
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (c) 2004 (GPU Free Documentation License)
Last Updated: Tue Jul 20 12:14:51 EDT 2004
|
|
|
|
|
|
|
|
