Skip to main content

Shell script to move MyISAM tables to innodb table with huge records



atertable.sh
mysql -proot -u root ctrdevdb_asset -e "ALTER TABLE assetproperty ENGINE='INNODB';"
mysql -proot -u root ctrdevdb_asset -e "ALTER TABLE assetpropertytrack ENGINE='INNODB';"
mysql -proot -u root ctrdevdb_asset -e "ALTER TABLE assettrack ENGINE='INNODB';"

Comments