Control panel

Русский
Українська
English

Support chat

Are you a customer?

Select the type of request:

0-800-307-307 Hotline
+38 (044) 392-74-33 Kiev
+38 (057) 728-39-00 Kharkiv
+38 (056) 794-38-31 Dnipro
+38 (032) 229-58-93 Lviv
+38 (048) 738-57-70 Odessa
+38(093) 170-15-42 Life
+38 (067) 400-88-44 Kievstar
+1(888)393-24-51 USA, Toll free
+44(131)507-01-14 Great Britain
+7 (499) 348-28-61 Moscow

2.7.15. Changing the storage type

Attention! Before taking any action, it is important to create a backup Database.

To convert storage type, you can also use PHP script.

Storage type conversions in MySQL tables, for example, from MyISAM to InnoDB, can be done in the following ways:

SQL queries
Console commands

To change the storage type of individual tables, connect to the database with phpMyAdmin or any other MySQL client and for the tables you want execute SQL query kind:

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.

To change the storage type for all tables in the database, use the console program 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.