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
2017-11-29, 1762🔥, 0💬
Related Topics:
