Extraction From MySQL’s Binary Log
Learn how to extract log data from MySQL and export it to CSV.
Most popular relational database management system (RDBMS) solutions keep a log file of all changes to the database, including changes due to data manipulation language (DML) statements such as INSERT, UPDATE, and DELETE, as well as data definition language (DDL) statements such as CREATE and DROP.
Each database calls this log file by a different name, but all serve the same purpose.
In Microsoft SQL Server, the log file is called the transaction log.
In Oracle, the log file is called the redolog.
In PostgreSQL, the log file is called the write-ahead log (WAL).
In MySQL, the log file is called the ...