Here's a procedure to convert tables from MyISAM to InnoDB in an existing Magnolia CMS installation:
- Backup your database.
- Create the script.
The following command will create a
Next,replace all the
Next, write the output to
<DATABASE_NAME>_innodb.sql. Be sure to change
<DATABASE_NAME>as it fits.
Run the script. This command will load the dump file we created in the last step.
Verify it by running this command in MySQL:
For more information see:
- Converting Tables from Other Storage Engines to InnoDB.
- How to Convert MySQL from MyISAM to InnoDB Using a Script.
For how to select the InnoDB storage engine for MySQL on a new Magnolia CMS installation see Setting up Jackrabbit persistence manager.