MySQL - location of binary log file?

[ash73]

1. Where does MySQL store the binary log file please?

2. Is binary logging enabled by default? If not, how do I enable it?

3. And how do I view it?

Thanks.

[pwilson]

1. Where does MySQL store the binary log file please?

2. Is binary logging enabled by default? If not, how do I enable it?

3. And how do I view it?

Thanks.

Hopefully the following output will answer some of these questions:

Code: Select all

/opt/bin/ps faxo "%U %t %p %a" | grep mysql
admin          00:00 13847          \_ grep mysql
admin    10-15:14:50 10971 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/var/lock/qmysql.pid --user=admin
admin    10-15:14:50 11275  \_ /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=admin --pid-file=/var/lock/qmysql.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
admin     1-03:37:59  7423 /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/mariadb/my-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/MD0_DATA/.system/data --user= --default-storage-engine=MyISAM --wait_timeout=2628000 --pid-file=/var/lock/mariadb.pid --tmpdir=/share/MD0_DATA/.system/tmp
admin     1-03:37:59  7767  \_ /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/MD0_DATA/.system/data --plugin-dir=/usr/local/mariadb/lib/plugin --user= --default-storage-engine=MyISAM --wait-timeout=2628000 --tmpdir=/share/MD0_DATA/.system/tmp --log-error=/share/MD0_DATA/.system/data/NASTY2.err --pid-file=/var/lock/mariadb.pid --socket=/tmp/mysql_mediadb.sock --port=3310

[schumaku]

Be careful not to mix-up MySQL and MariaDB...