Results 1 to 1 of 1
Feb 23, 2014, 01:12 #1
- Join Date
- Jan 2012
- 0 Post(s)
- 0 Thread(s)
Bulk changing table type and collation
All my database tables are MyISAM, and the collation for each is latin1_general_ci. I was thinking about switching to a popular CMS and was playing around with WordPress and Drupal. I discovered that both use InnoDB tables, with utf8_general_ci for collation.
Even if I'm not able to switch to a CMS, I'm wondering if there would be an advantage to switching to InnoDB and utf8_general_ci anyway. Is there a command I can type into phpMyAdmin > SQL that will change all my settings to InnoDB, utf8_general_ci, or do I have to do it one table at a time?