MySQL Forums
Forum List  »  InnoDB

Error 1034
Posted by: Wim Roffel
Date: May 19, 2014 05:56AM

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.

Options: ReplyQuote


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.