I have been having trouble with rebuilding a database from backup.
The backup consists of the MYD and frm files only. Therefore, I need to rebuild the myi file. I am using MySQL4.0.14 on Mac OS X. I use the myisamchk command to rebuild the database, in the following way
shell>/path/to/mysql/bin/myisamchk -r -q table_name
However, I get an error (45), "Operation not permitted" when I try doing this. The files are owned by mysql:wheel with permissions 660. The data directory is mounted on a NFS disk which is running on a Alpha Server 4100. The OS is Compaq Digital Unix OSFI V5.1.
I have rebuilt several tables before but have never faced this problem. Google did not yield much either. It would be great if someone could tell me what is going on/ what I can do to rebuild the table.
Thanks in advance.
Sincerely,
Rishi Pande
smime.p7s
Description: S/MIME cryptographic signature
