How todo I convert a database from MyISAM to InnoDB ?

I am going to convert all the tables of 500MB database from MyISAM to InnoDB to see whether it will improve the overall performance of a busy Drupal6Drupal 6 site. I am wondering what is the best (i.e. safest/easiest/fastest) way to do the conversion?

Thanks.

Corrected Speeling and Spacing

Source Link

edit approved Oct 13, 2011 at 22:37

RolandoMySQLDBA

1.6k
1
11
22

How to convert a database from MyIsamMyISAM to InnoDB ?

I am going to convert all the tables of 500MB500MB database from MyIsamMyISAM to InnoDB to see whether it will improve the overall performance of a busy Drupal 6siteDrupal6 site. I am wondering what is the best (i.e. safest/easiest/fastest) way to do the conversion?

Thanks

edited tags

Link

edited Jun 7, 2011 at 22:36

RolandoMySQLDBA

1.6k
1
11
22

Tweeted twitter.com/#!/StackDrupal/status/77890970594713601

occurred Jun 7, 2011 at 0:13

Source Link

asked Jun 6, 2011 at 22:24

alfish

1.9k
2
28
45

Loading

Stack Exchange Network

Return to Question

How todo I convert a database from MyISAM to InnoDB ?

How to convert a database from MyISAM to InnoDB ?

How do I convert a database from MyISAM to InnoDB?

How to convert a database from MyIsamMyISAM to InnoDB ?

How to convert a database from MyIsam to InnoDB ?

How to convert a database from MyISAM to InnoDB ?