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
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.