Myisamchk says my file doesn't exist

Databases
1

I had a table get corrupted so I tried to Repair it. It said it was successful, so than I Optimized it. But after all that, it still didn’t seem to fix the damaged table.

So then I learned about myisamchk online and gave it a try. Here is what I entered on the command line once I got onto my server using SSH:

myisamchk -r /var/lib/mysql/exampleTableName.MYI

I got the following response:

myisamchk: error: File ‘/var/lib/mysq/exampleTableName.MYI’ doesn’t exist

Can someone please help me know why I’m getting this? This is the exact path and everything.

Thanks!

2

Did you try using the drive at the beginning of the path? eg.
C:\var\lib\mysq\exampleTableName.MYI

3

I’m on an iMac using SSH to access my remote server. So C:\ does not apply in this situation. Can you think what else might be wrong?

Thanks!

4

Permission settings?

5

I normally use an app called Querious to manage the database, so I’m not as familiar with using the command line. Can you point me in the right direction on how I would check permissions?

Thank you.

6

I’ve only ever had Windows where I can go to the folder and right-click to see “properties”.
That and my FTP app shows them.

Sorry, I don’t know how to do it on iMac

7

Not to be funny, but is this the command that you actually entered? If so, you need to replace exampleTableName with the real name of the table unless, of course, exampleTableName is the name of the corrupted table.

8

In this example, I replaced the real name of my table with exampleTableName. Can you think of why else this may be happening?

Thank you!

9

Try this:

myisamchk -r /var/lib/mysql/DatabaseName/TableName.MYI
10

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.