MySQL slow query log, disaster log recovery, error log

Disaster log

All DDL (Create, DROP, and alter) and DML (INSERT, UPDATE, DELETE_ statements, but not query statements) are logged

Open Mysql.ini Find binary Logging
Revision changed to
Binary Logging. Log - = "ABC"

Restart MySQL


Find E:\AppServ\MySQL\data

Two more files below
abc.000001
Abc.index

Open Mysql.ini, find [client] revision to

[Client]
#no-beep

To create a new test environment:

1. New Test table

2. Create a new ID and name two fields

3. Inserting data (optional)

4. Open cmd

5. CD E:\AppServ\MySQL\bin

6.

MySQL slow query log, disaster log recovery, error log