Modify Innodb storage engine to MyISAM_MRG will make data lost.

MariaDB [zbdba]> show create table zbdba\G

*************************** 1. row ***************************

       Table: zbdba

Create Table: CREATE TABLE `zbdba` (

  `id` int(11) NOT NULL,

  `name` varchar(20) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.000 sec)

MariaDB [zbdba]>

MariaDB [zbdba]>

MariaDB [zbdba]> insert into zbdba() values(1, 'aa');

Query OK, 1 row affected (0.001 sec)

MariaDB [zbdba]> insert into zbdba() values(2, 'bb');

Query OK, 1 row affected (0.001 sec)

MariaDB [zbdba]> insert into zbdba() values(3, 'cc');

Query OK, 1 row affected (0.001 sec)

MariaDB [zbdba]> select * from zbdba;

+----+------+

| id | name |

+----+------+

|  1 | aa   |

|  2 | bb   |

|  3 | cc   |

+----+------+

3 rows in set (0.001 sec)

MariaDB [zbdba]>

MariaDB [zbdba]>

MariaDB [zbdba]> ALTER TABLE zbdba ENGINE = MRG_MYISAM;

Query OK, 0 rows affected (0.005 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [zbdba]> select * from zbdba;

Empty set (0.000 sec)