Enabling MySQL Binary Logs

MySQL binary log contains records of all changes to a databases—both data & structure—as well as how long each statement took to execute. It logs SQL statements such as CREATE, ALTER, INSERT, UPDATE & DELETE with the exception of SELECT & SHOW which have no effect on the data.