Is there any migration procedures or tools to migrate a Database (Liferay database to be exact) from InnoDB to PBXT?
From stackoverflow
-
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.
-
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
0 comments:
Post a Comment