How To Turn on Binary Logs
Q
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration
✍: 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)
2007-05-11, 5425👍, 0💬
Related Topics:
