Archive

HowTo: Quick and dirty MyISAM to InnoDB convert while importing

Recently, I've been playing around with the all-mighty MariaDB + Galera Multi-Master cluster!

Yeah, one thing that got me chasing my own tail was the fact that Galera does not support MyISAM... damn... the pain!

Anyway, I figured a quick and dirty trick to import DBs to galera:

mysql -u root -p my_db < <( zcat my_db.sql.gz | sed -r "s@MyISAM@InnoDB@" )

Yeah, that easy...