speters,
Wednesday, October 09, 2002, 2:09:30 AM, you wrote:
samdc> I think i have a damaged table in one of my databases.
samdc> I can do a SELECT count(*) from table
samdc> on every table in the db with no problem, except for 1
samdc> of them, the query just sits for a while.
samdc> So i assum
I think i have a damaged table in one of my databases.
I can do a SELECT count(*) from table
on every table in the db with no problem, except for 1
of them, the query just sits for a while.
So i assume this table is damaged. does anyone have any suggestions as to
what i can do about this?
tests
Hi,
> mysql> select * from logezboo;
> ERROR 1016: Can't open file: 'logezboo.MYD'. (errno: 145)
shut down your mysql, change to your MySQL data directory (as root or the user
MySQL runs as) and run:
myisamchk -r */*.MYI
and then restart MySQL after that and you should be back and running.
Hello eveyone,
Newbie Alert!
I am having trouble with one of my tables in a MySQL database. After I had
a power outage and restarted my system was not able to read info from that
table. Below is the Error messages I get when I try to access the table
from the command line client.
Help!
Thanks
