Announcement

Collapse
No announcement yet.

InnoDB & MyISAM - Whats the difference? Which is best? Why does my db have both??

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB & MyISAM - Whats the difference? Which is best? Why does my db have both??

    I have those 2 types of tables in my database, and Im wondering why. Seems its best to have MyISAM tables since they store 3 files instead of the 1 frm file. I know a lot of people think that they have lost their data b/c InnoDB only stores 1 file, but stores the data in ibdata1 in the mysql data directory.

    See my previous thread trying to get help on this:
    http://www.vbulletin.com/forum/showthread.php?t=223931

    I KNEW I HAD MY DATA SOMEWHERE!

    But if you want to know how I got it back please email me as I dont feel like typing it all.




    But back to the topic at hand, I need to know if its ok to convert my InnoDB tables to MYISAM, and how did I get InnoDB tables in the first place?

    Note: I was previously using mysqli, but then I had to switch servers and the new one didnt have it so...
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X