Search code examples
mysqllinuxsedbackupinnodb

MySQL Import with TYPE=InnoDB

I have a huge MySQL backup file (like 4-5 GB) with TYPE=InnoDB but the database I am gonna import in is a higher version and it does not accept ENGINE=InnoDB instead. Is there a way so that I can replace TYPE=InnoDB by ENGINE=InnoDB by command line in Linux.

Solution

    1. Create backup of your original SQL dump file.

    2. Run

      sed -i 's/TYPE=InnoDB/ENGINE=InnoDB/g' yourfile.sql