echo "[server]" > /etc/mysql/conf.d/binlog-do-db-bug.cnf
echo "log_bin = /var/log/mysql/mariadb-bin" >> /etc/mysql/conf.d/binlog-do-db-bug.cnf
systemctl restart mariadb 

mariadb -e "create database if not exists binlog_do_db_bug"
mariadb binlog_do_db_bug -e "drop table if exists innodb"
mariadb binlog_do_db_bug -e "create table innodb (col int(11) primary key AUTO_INCREMENT) engine innodb"

mariadb binlog_do_db_bug -e "insert into innodb values()"
mariadb binlog_do_db_bug -e "select count(*) as innodb_ok from innodb"

mariadb binlog_do_db_bug -e "drop table if exists myisam"
mariadb binlog_do_db_bug -e "create table myisam (col int(11) primary key AUTO_INCREMENT) engine myisam"

mariadb binlog_do_db_bug -e "insert into myisam values()"
mariadb binlog_do_db_bug -e "select count(*) as myisam_ok from myisam"

mariadb -e "drop database if exists binlog_do_db_bug_import; create database binlog_do_db_bug_import;"
mariadb-dump binlog_do_db_bug | mysql binlog_do_db_bug_import

mariadb binlog_do_db_bug_import -e "select count(*) as innodb_ok from innodb"
mariadb binlog_do_db_bug_import -e "select count(*) as myisam_ok from myisam"

echo "[server]" > /etc/mysql/conf.d/binlog-do-db-bug.cnf
echo "log_bin = /var/log/mysql/mariadb-bin" >> /etc/mysql/conf.d/binlog-do-db-bug.cnf
echo "binlog_do_db = somedb" >> /etc/mysql/conf.d/binlog-do-db-bug.cnf

systemctl restart mariadb

mariadb-dump binlog_do_db_bug | mysql binlog_do_db_bug_import

mariadb binlog_do_db_bug_import -e "select count(*) as innodb_bug from innodb"
mariadb binlog_do_db_bug_import -e "select count(*) as myisam_ok from myisam"
