Migrate InnoDB tables to PBXT

Question

Is there any migration procedures or tools to migrate a Database (Liferay database to be exact) from InnoDB to PBXT?

Answer 1

what's wrong with just doing an ALTER TABLE? you might have to remove the foreign keys, change all of the tables, and add foreign keys back.

Answer 2

Run

ALTER TABLE my_table_name ENGINE=PBXT;

for each of your tables. If you have lots of tables, take a look at Maatkit as a possible automation solution. With it, you'd do something like:

mk-find <db_name> --engine InnoDB --exec "ALTER TABLE %D.%N ENGINE=PBXT" --print