[SOLVED] Something Has Broken MySQL

[msf004]

The past few days I stopped getting my daily email reports.

I have read through the many posts and tried a few suggestions with no success.

I deleted the directory as recommended in another post:

rm -rf /opt/zimbra/logger/db/*

Now, if I run:

[zimbra: ./db] # logmysql.server start
[zimbra: ./db] # Starting mysqld daemon with databases from /opt/zimbra/logger/db/data
STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
090402 09:45:53  mysqld ended

Or, I have also tried:

[zimbra: ./data] # zmloggerctl start 
[zimbra: ./data] # Starting mysqld daemon with databases from /opt/zimbra/logger/db/data
STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
090402 09:44:37  mysqld ended

...and:

[zimbra: ./db] # logmysqladmin status
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!

I am obviously missing something. Any suggestions?

Thanks.

[msf004]

Sorry for the post. After enough digging around I learned of the zmloggerinit command that is located in the libexec directory.

Running /opt/zimbra/libexec/zmloggerinit seems to have rebuilt the tables that I deleted from my rm -rf /opt/zimbra/logger/db/* command.

Thanks