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