Added to Tiki 8
InnoDB has been added to Tiki 8 as experimental, and became the default in Tiki18.
The rest of this page is only kept for posterity.
Introduction
[+]Wishes
Open
Pending
| Rating | Subject | Submitted By | Importance | Easy to solve ? | Priority | Category | Volunteered to solve | Created | Modified | |
|---|---|---|---|---|---|---|---|---|---|---|
| DB Error on attempting to edit Details/Options of menu items - cannot update any menu options | Coyote | 7 | 5 | 35 |
| 21 Feb 24 | 21 Mar 25 |
Fixed
Interested community members
No results for query.
Database upgrades
When adding an engine dependent patch, the engine independent SQL must be put in the YYYYMMDD_description_tiki.sql file. The engine dependent parts must be put in an accompanying php file, specifying a post_YYYYMMDD_description_tiki function.
Example: Add a table with a fulltext index
20110918_tiki_test_tiki.sql
Copy to clipboard
DROP TABLE IF EXISTS `tiki_test`; CREATE TABLE `tiki_test` ( `title` varchar(255) default NULL, KEY `title` (`title`) ) ENGINE=MyISAM;
and a PHP file specifying the engine dependent part
20110918_tiki_test_tiki.php
Copy to clipboard
function post_20110918_tiki_test_tiki( $installer ) { if($installer->isMySQLFulltextSearchSupported()) { $installer->query( "CREATE FULLTEXT INDEX ft_test ON tiki_test(`title`);"); } }
ToDo
Remove "MySQL Full-Text Search" in config search
If the config search "Preference Filters" is set to Advanced, "MySQL Full-Text Search" is still displayed in the results. It shouldn't be.
Migrating existing databases to InnoDB
Migration steps
- Make sure InnoDB is integrated in the standard/SVN Tiki release. Otherwise you may be unable to do any upgrades later.
- Do a full backup of your current database/installation
- Upgrade to the latest Tiki version (8.0 SVN or later).
- Disable MySQL fulltext search in Tiki. It's not supported by InnoDB, and you won't be able to disable it from the GUI after the conversion
- Drop all MyISAM fulltext indexes
- Alter the database engine for all tables to InnoDB
Steps 5 and 6 are defined in the file db/tiki_convert_myisam_to_innodb.sql.
To be tested
- TRIM (would be nice that it works here too...)