Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Turn on Binary Logs
How To Turn on Binary Logs? - MySQL FAQs - Server Daemon mysqld Administration
✍: FYIcenter.com
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, 5206👍, 0💬
Popular Posts:
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
How To Download and install PSP Evaluation? - PSP Tutorials - Fading Images to Background Colors wit...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...
What will be printed as the result of the operation below: main() { int x=10, y=15; x = x++; y = ++y...