Everythig from MyISAM to INNODB, how?

Richard G

Verified User
Joined
Jul 6, 2008
Messages
4,218
Location
Maastricht
That's indeed an alternative way Wattie. I also encountered that somewhere too on the internet.

But also when doing it like your suggestion, it's better to create a backup first anyway. I felt safer that way.

Thank you anyway, because your tip can always be used too.
 

BBM

Verified User
Joined
Jun 8, 2013
Messages
330
Location
Dutch Mountains
FYI,
I noticed I had a lot of mixed storage engined tables in certain databases and so I converted a number of them completely to InnoDB, through the ALTER TABLE way and it works nice and smooth.
Just a few clicks to go through a database(s).
 

Richard G

Verified User
Joined
Jul 6, 2008
Messages
4,218
Location
Maastricht
Yep thanks. I did that too when I asked this and worked fine.
But I'm glad I did not do it with everythings. Since it seemed applications are better with MyIsam.
 
Top