Hi,
I think the syntax is to be verified.
myisamchk * * -u root -p *
///*.*
mysql will accept only if the passwords is next to "-p" option
**: some frequently used options are mentioned below
-r, --recover
-o, --safe-recover
-e, --extend-check
-q, --quick
-S, --sort-index
-f, --force ( to b
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 inde
---
-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 gi
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/