MySQL MyISAM engine converted to InnoDB operation record

Go to MySQL command line mode: # MYSQL-UROOT-PPWD

1. See what storage engine MySQL provides:

Mysql> show engines;

2. Check the default storage engine currently provided by MySQL:

Mysql> Show variables like '%storage_engine% ';

3. Display the Database list:

mysql> show databases;

4. Enter the database to be modified

mysql> use FreeSWITCH;

5. List all tables of the FreeSWITCH library

Mysql> Show tables;

6. View the current engine that needs the table

Mysql> Show CREATE Table CDR; Current table: Engine=myisam

7. Modify the table's storage engine to InnoDB (This command can also change InnoDB to MyISAM)

Mysql> ALTER TABLE CDR Engine=innodb;

8. Restart MySQL after conversion is complete

Service mysqld Restart

　　

MySQL MyISAM engine converted to InnoDB operation record