Posted By

rowntreerob on 01/14/09


Tagged

mysql


Versions (?)

convert mysql engine to innodb


 / Published in: Bash
 

  1. mysql -u root snappsv2tst -e "show table status \G;" | grep 'Name:' | sed 's/^\(.*\)/ALTER TABLE \1/' snappsv2_engine_alter.sql | sed 's/$/ ENGINE=INNODB;/' > snappsv2_engine_alter.sql
  2.  
  3. mysql -u root dbname < snappsv2_engine_alter.sql

Report this snippet  

You need to login to post a comment.