Recently I've migrated some schemas from mysql 4
instance into an instance of mysql 5.6
by mysqldump
and import operations. After some syntax adjustments, I could import the dump file successfully.
After the import, I went over the log file and i found some issues. Does anyone know what is that and how to fix it?
InnoDB: Error in pars0opt.cc: table cars/cars_ftr_a has prefix_len != 0
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_BEING_DELETED'
InnoDB: in InnoDB data dictionary has unknown flags 50.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_BEING_DELETED_CACHE'
InnoDB: in InnoDB data dictionary has unknown flags 50.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_CONFIG'
InnoDB: in InnoDB data dictionary has unknown flags 50.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_DELETED'
InnoDB: in InnoDB data dictionary has unknown flags 50.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_DELETED_CACHE'
InnoDB: in InnoDB data dictionary has unknown flags 50.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_1'
InnoDB: in InnoDB data dictionary has unknown flags 40.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_2'
InnoDB: in InnoDB data dictionary has unknown flags 40.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_3'
InnoDB: in InnoDB data dictionary has unknown flags 40.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_4'
InnoDB: in InnoDB data dictionary has unknown flags 40.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_5'
InnoDB: in InnoDB data dictionary has unknown flags 40.
2017-08-16 17:14:15 7fd3081c4700 InnoDB: Warning: table 'cars/FTS_00000000000002cb_000000000000040c_INDEX_6'
InnoDB: in InnoDB data dictionary has unknown flags 40.
Edit (adding create table statement)
Create Table: CREATE TABLE `cars_ftr_a` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`manufacturer` varchar(100) NOT NULL DEFAULT '',
`model` varchar(255) NOT NULL DEFAULT '',
`object_type` int(10) unsigned NOT NULL DEFAULT '0',
`fts_string` text NOT NULL,
`manufactor_id` int(10) unsigned NOT NULL DEFAULT '0',
`model_id` int(10) unsigned NOT NULL DEFAULT '0',
`version_id` int(10) unsigned NOT NULL DEFAULT '0',
`version` varchar(100) NOT NULL DEFAULT '',
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
`group_name` varchar(100) DEFAULT NULL,
`a` int(10) unsigned DEFAULT NULL,
`b` varchar(100) NOT NULL DEFAULT '',
`price` int(10) unsigned NOT NULL DEFAULT '0',
`c` int(10) unsigned NOT NULL DEFAULT '0',
`d` varchar(100) NOT NULL DEFAULT '',
`e` float NOT NULL DEFAULT '0',
`f` int(10) unsigned NOT NULL DEFAULT '0',
`g` int(10) unsigned NOT NULL DEFAULT '0',
`h` int(10) unsigned NOT NULL DEFAULT '0',
`i` smallint(6) unsigned NOT NULL DEFAULT '0',
`j` varchar(100) NOT NULL DEFAULT '',
`j` int(10) unsigned NOT NULL DEFAULT '0',
`l` int(10) unsigned NOT NULL DEFAULT '0',
`m` int(10) unsigned NOT NULL DEFAULT '0',
`n` varchar(100) NOT NULL DEFAULT '',
`o` int(10) unsigned NOT NULL DEFAULT '0',
`o` text NOT NULL,
`p` varchar(100) NOT NULL DEFAULT '',
`q` int(10) unsigned NOT NULL DEFAULT '0',
`r` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`,`fts_string`(10)),
FULLTEXT KEY `fts_string` (`fts_string`)
) ENGINE=InnoDB DEFAULT CHARSET=hebrew