Mysql write ahead logs (bin-logs)

enable mysql bin-logs / write ahead logs (wal)

log_bin #enable bin-logs
expire_logs_day=10 #in days
max_binlog_size=5M #maximum size
#log_bin_index=<filename> #filename of the index-file
#binlog_do_db=<dbname> #enable bin-log just for that db
binlog_ignore_db=mysql #do not write bin-log for mentioned database

if you want to inlcude/exclude more than one db, the syntax is to mention that databases in different lines.

how to writeback mysql bin-logs to the myslq-database

mysql> show binary logs;
+--------------------+-----------+
| Log_name           | File_size |
+--------------------+-----------+
| KURS006-bin.000001 |       125 |
| KURS006-bin.000002 |       420 |
| KURS006-bin.000003 |       125 |
| KURS006-bin.000004 |     57484 |
| KURS006-bin.000005 |       106 |
+--------------------+-----------+
5 rows in set (0.00 sec)

Recent changes