Hi,
I think the syntax is to be verified.
myisamchk *<options> * -u root -p *<password>
/<datadir>/<DB>/<tablename>*.*
mysql will accept only if the passwords is next to "-p" option
*<options>*: some frequently used options are mentioned below
-r, --recover
-o, --safe-recover
-e, --extend-check
-q, --quick
-S, --sort-index
-f, --force ( to be used cautiously)
i hope this will solve your issue :-)
--
Regards,
N.PradeepChandru,
MySQL DBA, Cricinfo Pvt Ltd.
Dilipkumar wrote:
Hi,
Yes it can be repaired using
myisamchk -u root -p datadirectory the table name as tablename.*
password
this will check the data and also the index file also.
Payne wrote:
hi, I got a table where the myi isn't able to re be read. I tried to
run myisam but it give an error about the index.
Do I need to drop the table? Can it be repaired?
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
