I am running a LAMP server with shared hosting. I have several clients using the same CMS software that uses MySQL as its base database. I get error 145 in my /var/log/mysqld.logregarding file mod_statistics.MYI:
120713 8:53:22 [ERROR] / usr / libexec / mysqld: Cannot open file: 'mod_statistics.MYI' (errno: 145)
I know how to fix error 145: this is not a problem. However, FIND the right mod_statistics.MYIproblem for me, as there are many clients on this server who have their own copies of this table.
My question is: How do I change the format of MySQL logging to add the full path to this file to the output log file? I really do not like going through each client loading this table to make sure it is damaged.
I have Googled and read the MySQL log file documentation, which does not discuss changing the file format.
THANK!
Ryan
source
share