How To Turn on Binary Logs
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration
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, 4897👍, 0💬
How do you handle change request? Normally change request are handled by preparing an Impact analysi...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configu...
What is the version information in XML? “version” tag shows which version of XML is used.