MySQL storage engine Part 2 – How to convert data in safe?

 InnoDB vs. MyISAM

      InnoDB is a Transaction-safe (ACID compliant) storage engine, it can be commit, rollback and crash-recovery capabilities to protect user data.

MyISAM is non-transaction-safe, but use low byte for storing data and fast process. 

You can have multiple types engines in one database such as you can have many cars park in your same garage.

• What’s the disadvantage if put multiple engines in the same database?

The different engines have their own engine type to make you difficult to manage your database. 

**Use INSERT INTO & SELECT clause to insert data from database_1 to database_2.

Please do not drop the table that already consist massive data, before you decide to drop any table, you must be save the data as export the file and insert the data into the other new table; otherwise, you will lost all the important data that would be very difficult to get recovery.