Breaking News: Grepper is joining You.com. Read the official announcement!

Convert All InnoDB Tables To MyISAM

Add Answer

Jason M Potter answered on July 15, 2022 Popularity 3/10 Helpfulness 1/10

answer Convert All InnoDB Tables To MyISAM

related Convert MyISAM Tables To InnoDB

related convert all tables in database to from myisam to innodb

Convert All InnoDB Tables To MyISAM

Comment

## Convert ALL InnoDB tables in ALL databases to MyISAM
# This command will continue even if an individual table fails to convert.
# output is saved to convert-to-myisam.log
mysql -Bse 'SELECT CONCAT("ALTER TABLE ",table_schema,".",table_name," ENGINE=MyISAM;") FROM information_schema.tables WHERE table_schema NOT IN ("mysql","information_schema","performance_schema") AND Engine = "InnoDB";' | while read -r i; do echo $i; mysql -e "$i"; done | tee convert-to-myisam.log

Popularity 3/10 Helpfulness 1/10 Language sql

Source: www.liquidweb.com

Tags: innodb myisam sql

Link to this answer
Share Copy Link

Contributed on Oct 15 2022

Jason M Potter

0 Answers Avg Quality 2/10

Closely Related Answers

Convert MyISAM Tables To InnoDB

Comment

## Convert ALL MyISAM tables in ALL databases to InnoDB
# This command will continue even if an individual table fails to convert.
# output is saved to convert-to-innodb.log
mysql -Bse 'SELECT CONCAT("ALTER TABLE ",table_schema,".",table_name," ENGINE=InnoDB;") FROM information_schema.tables WHERE table_schema NOT IN ("mysql","information_schema","performance_schema") AND Engine = "MyISAM";' | while read -r i; do echo $i; mysql -e "$i"; done | tee convert-to-innodb.log

Popularity 5/10 Helpfulness 7/10 Language sql

Source: www.liquidweb.com

Tags: innodb myisam sql

Link to this answer
Share Copy Link

Contributed on Oct 15 2022

Jason M Potter

0 Answers Avg Quality 2/10

convert all tables in database to from myisam to innodb

Comment

SET @DATABASE_NAME = 'name_of_your_db';

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

Popularity 4/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: innodb sql myisam database

Link to this answer
Share Copy Link

Contributed on Jul 15 2022

Emad Abdulhannan

0 Answers Avg Quality 2/10

Convert All InnoDB Tables To MyISAM

Contents

More Related Answers

Convert All InnoDB Tables To MyISAM

Closely Related Answers

Convert MyISAM Tables To InnoDB

convert all tables in database to from myisam to innodb

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.