Linux
  • 109 Views
  • 22/08/2024

How to change all tables in a MySQL database from the MyISAM storage engine to InnoDB

To change all tables in a MySQL database from the MyISAM storage engine to InnoDB, you can use a script that automates this process

Automated Script Using Bash
 

#!/bin/bash

DATABASE='your_database_name'
USER='your_username'
PASS='your_password'

mysql -u$USER -p$PASS -D$DATABASE -e "SELECT table_name FROM information_schema.tables WHERE engine = 'MyISAM' AND table_schema = '$DATABASE'" | grep -v table_name | while read TABLE; do
    mysql -u$USER -p$PASS -D$DATABASE -e "ALTER TABLE $TABLE ENGINE = InnoDB;"
done

Replace your_database_name, your_username, and your_password with your database details.

Thanks for visit my website