We help IT Professionals succeed at work.

Incorrect key file for table 'soft_data'; try to repair it

i-CONICA
i-CONICA asked
on
634 Views
Last Modified: 2012-05-08
Hi,
Bit of an emergency!... :S

I attempted to figure out the syntax needed to explain an index on a table in a live production database, stupid I know...

Now I get this error and the table is offline, rendering the site useless. Incorrect key file for table 'soft_data'; try to repair it.

I've attempted to repair it and I get this:
nzua9c8.soft_data      repair      Error      Incorrect key file for table 'soft_data'; try to r...
nzua9c8.soft_data      repair      error      Corrupt

Is there anything I can do to resurrect this table?

Thanks.
Comment
Watch Question

Senior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi,

I've run this query and it still outputs:
nzua9c8.soft_data      repair      Error      Incorrect key file for table 'soft_data'; try to r...
nzua9c8.soft_data      repair      error      Corrupt

I can't download a dump of the database it gets as far as the corrupt table and stops... :S
UmeshSenior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
None of the above works...

So I take it there's no way to resurrect this?
UmeshSenior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I cannot access these files, I have the database on a shared host... :(
UmeshSenior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I have PHPMyAdmin access. This is what I've been running the queries on. I do have SSH access, but it's asking me to set up a private key, and use something like putty, which I've downloaded and tried, but can't connect. I'm not familiar enough with SSH to use it in that way.

Thanks for the help so far. :)
UmeshSenior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I've asked them to provide the files... If they won't provide those, I'll attempt to gain SSH access and get back to you.

With SSH, what do you think the chances (with your help) that I'll be able to get at least some of the data back?

Thanks.
UmeshSenior Principal Technical Support Engineer
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi,

Luckily, the host had a backup of the database. They restored it to a resent one and after running REPAIR, all tables are showing OK.

Thank you for the help ushastry. :)
UmeshSenior Principal Technical Support Engineer
Top Expert 2009

Commented:
You are welcome.

Regards,
Umesh
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.