Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - What Is Binary Log File

By: FYIcenter.com

(Continued from previous topic...)

What Is Binary Log File?

MySQL server binary log file plays an important role in restoring database changes to the server. Main features on binary log files are:

  • Binary logs can be turned on by "--log-bin=fileBaseName" option on "mysqld".
  • Binary logs only records statements that are changing data in the database. So a simple SELECT statement will be not recorded in binary logs.
  • Binary logs are organized in multiple files with names like: base.index, base.000001, base.000002, etc. Each time when you restart the server, a new binary log file will be created.
  • Binary log files can be viewed by "mysqlbinlog" program.
  • Binary log files can be piped into back to the server as "mysqlbinlog base.000001 | mysql" for restoring data changes after a server crash.

(Continued on next topic...)

  1. What Is the MySQL Server Daemon - mysqld?
  2. What Are the "mysqld" Command Line Options?
  3. How To Start MySQL Server Daemon mysqld?
  4. How To Properly Shutdown MySQL Server Daemon mysqld?
  5. How Much Memory Does the Server Take?
  6. How To Turn on Query Logs?
  7. How To Turn on Error Logs?
  8. What Is Binary Log File?
  9. How To Turn on Binary Logs?
  10. How To Use mysqlbinlog to View Binary Logs?
  11. How To Run MySQL Server on a Different Port?
  12. How To Connect to MySQL Server on a Different Port?

MySQL Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: