Collections:
Turn on Binary Logs in MySQL
How To Turn on Binary Logs in MySQL?
✍: 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)
⇒ Viewing Log File with "mysqlbinlog" in MySQL
⇐ What Is Binary Log File in MySQL
2017-11-29, 1457🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...