Dear Chip,
myisamchk is not an SQL command, so it's not executed from the MySQL
Monitor (the SQL command line tool) but rather from a shell. Type
"myisamchk" at the shell prompt and you will see the options.
Or you can use the new version of PhpMyAdmin (www.phpmyadmin.com), this
has a built-in table check & table repair part.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 8:37 PM
Subject: My databases got hosed when the server went down hard!
> Geez, if it ain't one thing it's another. :-(
> My fbsd server went down hard today, now my mysql database is
supposedly
> gone.
> I see the .MYD, .MYI, and .FRM files in the /usr/var/db/mysql/
directory,
> but I get this -
>
> mysql> use bulletins
> Can't read dir of './bulletins/' (Errcode: 13)
> Database changed
> mysql> show tables;
> ERROR 12: Can't read dir of './bulletins/' (Errcode: 13)
> mysql> myisamchk -s /usr/var/db/mysql/bulletins/*.MYI;
> ERROR 1064: You have an error in your SQL syntax near 'myisamchk -s
/usr/var/db/mysql
> /bulletins/*.MYI' at line 1
>
> Obviously I don't know how to use myisamchk properly.
> In Webmin I see the icons for the database, but when I select it the
screen changes and shows
> This database has no tables.
>
> Hopefully these files can be restored, I can view them with cat and
they do contain the
> data that was entered previously.
>
> Chip Wiegand
> Computer Services
> www.simradusa.com
> [EMAIL PROTECTED]
> Simrad, Inc
> Lynnwood, WA
> 425-712-1138
>
> "There is no reason anyone would want a computer in their home."
> --Ken Olson, president, chairman and founder of Digital Equipment
Corp.,
> 1977
> (-- Then why do I have nine? Somebody help me!)
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
