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
