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, 1446🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...