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, 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:
---
-Original Message-
From: Payne [mailto:[EMAIL PROTECTED]
Sent: Monday, 8 May 2006 1:45 PM
To: mysql@lists.mysql.com
Subject: How to repair a table,
hi, I got a table where the myi isn't able to re be read. I tried to run
myisam but it give
