MySQL - location of binary log file?

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
ash73
Starting out
Posts: 38
Joined: Wed Sep 04, 2013 12:10 am

MySQL - location of binary log file?

Post by ash73 » Tue Apr 01, 2014 5:22 pm

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.

User avatar
pwilson
Guru
Posts: 22569
Joined: Fri Mar 06, 2009 11:20 am
Location: Victoria, BC, Canada (UTC-08:00)

Re: MySQL - location of binary log file?

Post by pwilson » Tue Apr 01, 2014 11:21 pm

ash73 wrote: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

Patrick M. Wilson
Victoria, BC Canada
QNAP TS-470 Pro w/ 4 * Western Digital WD30EFRX WD Reds (RAID5) - - Single 8.1TB Storage Pool FW: QTS 4.2.0 Build 20151023 - Kali Linux v1.06 (64bit)
Forums: View My Profile - Search My Posts - View My Photo - View My Location - Top Community Posters
QNAP: Turbo NAS User Manual - QNAP Wiki - QNAP Tutorials - QNAP FAQs

Please review: When you're asking a question, please include the following.

User avatar
schumaku
Guru
Posts: 43668
Joined: Mon Jan 21, 2008 4:41 pm
Location: Kloten (Zurich), Switzerland -- Skype: schumaku
Contact:

Re: MySQL - location of binary log file?

Post by schumaku » Wed Apr 02, 2014 3:21 am

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

Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”