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, 3152🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...