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

Converting A Single Table Between MyISAM and InnoDB

Jason M Potter answered on October 15, 2022 Popularity 3/10 Helpfulness 4/10

answer Converting A Single Table Between MyISAM and InnoDB

Converting A Single Table Between MyISAM and InnoDB

Comment

## Backup A Single Table To A File
mysqldump database_name table_name > backup-table_name.sql

## Convert A Single Table To InnoDB
mysql -Bse ‘ALTER TABLE database_name.table_name ENGINE=InnoDB;’

## Convert A Single Table To MyISAM:
mysql -Bse ‘ALTER TABLE database_name.table_name ENGINE=MyISAM;’

Popularity 3/10 Helpfulness 4/10 Language sql

Source: www.liquidweb.com

Tags: between innodb myisam sql

Link to this answer
Share Copy Link