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,
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
Hi Payne,
This should have all the info you need, there is also another command
myisamchk which requires the server to be down while it repairs.
mysqlcheck does not.
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
Regards
---