Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
cd /path/to/platform/sites/
drush sql-query "SHOW TABLES" | tail -n +2 | xargs -I '{}' echo "ALTER TABLE {} ENGINE=INNODB;" > alter_table.sql
perl -p -i -e 's/(search_[a-z_]+ ENGINE=)INNODB/\1MYISAM/g' alter_table.sql
cat alter_table.sql | `drush sql-connect`

This comment has been minimized.

Copy link

jackinloadup commented Nov 16, 2011

Just as a note to people using this. Don't forget to delete the alter_table.sql file.

Works like a charm omega8cc, Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.