Turn on Binary Logs in MySQL

Q

How To Turn on Binary Logs in MySQL?

✍: FYIcenter.com

A

If you want MySQL to write binary logs to a file, you can use the "--log-bin=fileBaseName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option:

>cd \mysql\bin
>mkdir \mysql\logs
>mysqld --log-bin=\mysql\logs\binary

Starts another command window, and enter the following commands:

>cd \mysql\bin
>mysql -u root -pretneciyf test

mysql> drop table test;
Query OK, 0 rows affected (0.12 sec)

mysql> create table test (name varchar(80));
Query OK, 0 rows affected (0.11 sec)

mysql> insert into test values ('dba.fyicenter.com');
Query OK, 1 row affected (0.03 sec)

 

Viewing Log File with "mysqlbinlog" in MySQL

What Is Binary Log File in MySQL

Server Daemon mysqld Administration in MySQL

⇑⇑ MySQL Database Tutorials

2017-11-29, 1409🔥, 0💬