Re: InnoDB table gets corrupt suddenly
This last time was a MySQL crash but all other previous where table corruption only. All worked ok except that table.
Create table looks like:
CREATE TABLE `rate_list` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tarifas_id` int(11) NOT NULL,
`destino` varchar(80) NOT NULL,
`importe` decimal(9,4) NOT NULL,
PRIMARY KEY (`id`),
KEY `tarifas_id` (`tarifas_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10891 DEFAULT CHARSET=latin1;
If I try to create it again I get:
ERROR 1050 (42S01): Table '`svb`.`rate_list`' already exists but it doesn't appear in table list nor queries could be done.
I will look for memory comsuption
Subject
Views
Written By
Posted
1920
July 03, 2015 09:02AM
1026
July 03, 2015 10:59AM
2952
July 03, 2015 12:42PM
1352
July 03, 2015 01:39PM
Re: InnoDB table gets corrupt suddenly
1231
July 03, 2015 02:52PM
1175
July 03, 2015 02:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.