ALTER TABLE table_name ENGINE=InnoDB;
Where instead of table_name
specify the desired table, and instead of InnoDB
- the type of storage engine you want.
mysql
(to use it you need connect via SSH to the hosting server). To convert all tables to InnoDB
run:
for n in `mysql -h host -u login -pPASSWORD name_БД -B -N -e "show tables;"`;do mysql -h host -u login -pPASSWORD name_БД -B -N -e "ALTER TABLE $n ENGINE=innodb;";done
In the specified command, you need to specify connection data to the database:
host
- database server.login
- the name of the database user.PASSWORD
- database user password.name_БД
- the name of the database.innodb
- storage type.Important! All data, except for the storage type, must be changed twice in the command. When you run the command, the output might look like this:
mysql: [Warning] Using a password on the command line interface can be insecure.
Do not be intimidated by such a message, this notification only indicates that using a password in a command is unsafe. If there is no other data, then the command was executed correctly.