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, 1409🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...