List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:September 23 2011 12:10pm
Subject:Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
View as plain text  
Someone seems to have deleted that file, which contains the description of the
corresponding table. Recreate the exact same table (EXACT, including keys, indices,
datatypes, encoding, the lot) and copy that tables's .frm file to replace the lost one.
Then pray to the elder gods and restart your mysqld to see if it works. 

----- Original Message -----

> From: "Shafi AHMED" <shafi.ahmed@stripped>
> To: mysql@stripped
> Sent: Friday, 23 September, 2011 1:42:26 PM
> Subject: mysqldump: Got error: 1017: Can't find file:
> './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK
> TABLES

> Folks

> I have a mysql database of 200G size and the backup fails due to the
> foll. Issue.

> mysqldump: Got error: 1017: Can't find file:
> './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK
> TABLES

> Can someone assist pls.?

> Best Rgs,
> Shafi AHMED

-- 
Bier met grenadyn 
Is als mosterd by den wyn 
Sy die't drinkt, is eene kwezel 
Hy die't drinkt, is ras een ezel 

Thread
mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESShafi AHMED23 Sep
Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESJohan De Meersman23 Sep
Re: mysqldump: Got error: 1017: Can't find file:'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESDan Nelson23 Sep
  • Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm'(errno: 24) when using LOCK TABLESPrabhat Kumar24 Sep
    • Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm'(errno: 24) when using LOCK TABLESSuresh Kuna24 Sep
      • RE: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESShafi AHMED26 Sep