Error 1034
I can no longer access one of my tables as it gives the following error:
#1034 - Incorrect key file for table 'ps_group_lang'; try to repair it
This even happens when I want to browse the table in phpMyAdmin. The table has only 6 rows and its structure is rather simple too.
When I do a database dump I get the following CREATE command for the table:
CREATE TABLE IF NOT EXISTS `ps_group_lang` (
`id_group` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id_group`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Probably due to the error the dump ignores the rows.
With MyIsam I had some tools but with InnoDb I am feeling lost. I am using MySQL version 5.5.16.
Subject
Views
Written By
Posted
Error 1034
3905
May 19, 2014 05:56AM
1369
May 20, 2014 05:06PM
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.