Stefan Hinz wrote:
> 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.
>
Thanks, I'm discovering there are a few of these commands to run from the
shell prompt, not from within MySQL.
Thanks,
--
Chip
>
> 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
--
Regards,
--
Chip Wiegand
CRW Computer Services
www.wiegand.org
[EMAIL PROTECTED]
<------------------>
Web page design
Consulting
PC Repair
<------------------>
---------------------------------------------------------------------
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
