Corrupt Table

[rjcunningham]

fetchmail is no longer running automatically, it will work if I manually tell it to fetch from within the admin section
I am getting the following error in my windows log
C:\Program Files\OTRS\MySQL\bin\mysqld.exe: Table '.\otrs\process_id' is marked as crashed and should be repaired

I have searched as much as possible and everything I find does note relate to my setup. I have installed a gui mysql tools app, but that does not seem to lead me to any type of table rebuild. via google I found command line syntax's to dump/rebuild/backup etc, etc but nothing seems to match my setup, none of my screens look like those screens.

can anyone give me a step by step method which may help this get back up and running. Honestly, I installed with all the defaults and other then a few minor config changes, I have not touched this system on the backend for over a year so I barely remember what I did.


Randy Cunningham
----------------------------------
OTRS 3.0.2
OS:Windows 2003 w. all default install apps

[jojo]

use the mysql cli and follow the instructions from the mysql admin book. Also your database admin should be able to help

[rjcunningham]

I don't' want to sound stupid, but I'm pretty sure I am when it comes to this

this is the only install of Mysql I am using, and I don't know anything about MySQL, like I said, I did the default installs and it worked, and it have not been back to it since. I am the dbadmin
I found command line instructions via google searches, but nothing seems to match what I am seeing on my server.

I'll keep searching and trying to make sense of what I find. but if anyone can point me to step by step commands, that would be awesome

[jojo]

open cmd
type mysql -u root
you should be in the command prompt of MySQL
type use otrs
now you can repair the table

[rjcunningham]

I get this
mysql> use otrs
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'otrs'
mysql>

[rjcunningham]

ok.i got this now
I did use otrs, then I got a message
database changed

is there a step to rebuild /repair ?

[rjcunningham]

so I've tried several things following a link i found about repairing databases..I get this far, but nothing seems to happen, I just get the arrow prompt

mysql> USE OTRS
Database changed
mysql> REPAIR TABLE process_id
->

[jojo]

try

REPAIR TABLE process_id;

and RTF MySQL Admin Manual!

[rjcunningham]

Thank you very much, that worked