Change tables from myisam to innodb

  • Resolved Susa38

    (@susa38)


    6 years, 11 months ago

    On my database I have all the tables from all in oneevent calendar in MyISAM type
    But I have the table “wp_ai1ec_event_category_meta” in InnoDB type

    1- Could I Change all the tables from all in one event calendar to innoDB type?
    2- Could I loose some information?
    3- I have to keep in mind something before the change?

Viewing 1 replies (of 1 total)

  • Hi @susa38

    If you convert a table(s) from MyISAM to InnoDB type, make sure that you have sufficient disk space to hold both the old and new tables during the process. InnoDB tables require more disk space than MyISAM tables. If an ALTER TABLE operation runs out of space, it starts a rollback, and that can cause loss of data. It is recommended to make a full database backup before proceeding with the task. If anything goes wrong, you can restore from backup.

Viewing 1 replies (of 1 total)
  • The topic ‘Change tables from myisam to innodb’ is closed to new replies.