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 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.
 * 1) log_bin_index= #filename of the index-file
 * 2) binlog_do_db= #enable bin-log just for that db

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

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