[rt-users] SQL problems

[Tom Lichti]

Rick Ellis wrote:
> Hi Guys,
> 
> While trying to track down why emails were not triggering ticket
> creation in rt3.0.9 on Solaris 8, I used mysqladmin 4.0.18-max to
> shutdown the database.
> 
> on restart, the server exited. Examining the logs, their was a table
> inconsistency logged against the RT database. I then restored it from
> the previous night backup and tried again.
> 

I had an issue similar to that two weeks ago. I seem to recall having to 
delete the following files from /usr/local/mysql/data/:

ib_arch_log_0000000000
ibdata1
ib_logfile0
ib_logfile1

I moved them first, then restarted and they were recreated. Might be 
related to your problem?

Tom