converting database to innodb

[antoniofalconx11426]

i think my database is on the verge of collapse and i hear that myisam is more prone to it and that innodb gives better performance with large databases.

im worried because i keep using the command line to fix the tables and then I go to check them again and it says they are still messed up. When i check through phpmyadmin says everything is ok but through command line it's not.

can someone show me how to convert the entire database over to innodb and switch over the collation to utf8_general_ci?

 

[ysmods]

No way afaik to do the entire db in one go, only on a per table level.

But read this first > http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html

ALTER TABLE table_name ENGINE=InnoDB;