IPB 4 and server optimisation

[ASTRAPI]

The best and more safe way is from ssh

Just run:

mysql -u root -p

then enter your mysql password

then type:

show databases;

then select the database you want to convert all tables to Innodb using:

use NAMEofDB;

and finally run for each table this:

ALTER TABLE tablename ENGINE = InnoDB;

 

Another nice automated trick to find out what commands should you use for your tables and not checking one by one is this:

mysql -u root -p -e "select concat('alter table ',TABLE_SCHEMA ,'.',table_name,' ENGINE=InnoDB;') FROM information_schema.TABLES where table_schema='database1' and engine = 'MyISAM';"

 

Just replace on the above command the "database1" with your database name and run it

 

Enjoy !