Not the answer you need?
Register and ask your own question!

Switch to InnoDB engine from MyISAM

pythondev1pythondev1 EntrantCurrent User Role Contributor
I am extremely new to percona. Like as of 6 months. I have used mysql but mostly sql server. So forgive me if this is a stupid question. How do you which from MyISAM to InnoDB engine? Do I create a new innodb table. Do a sql dump then get rid of the old table and rename the new table? Or do I just run
ALTER TABLE table_name ENGINE=InnoDB;

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.