Monday, February 21, 2011

Migrate InnoDB tables to PBXT

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