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)

 

Server Daemon mysqld Administration in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 215👍, 0💬