Re: Corruptions like crazy
Hi John,
In your previous message about using the "log-bin" and "bin-log-do-db" settings....please open a new forum thread to address that and your backup/recovery requirements with mysqldump.
Otherwise regarding this issue, I have 3 concerns/checks:
1. The disk drive needs to be checked for errors. this needs to be done first, maybe by getting help from your service provider.
2. You seem to be updating your mysql-server only and not the client tools. To see where you are currently at, please run the following and provide the output...also provide the output of your mysqld.log file after the upgrade you did to the server.
# rpm -qa | grep -i mysql
dependent on the output, running these commands may help you upgrade your client tools
# yum upgrade mysql-client mysql-shared mysql-shared-compat
3. Use the mysql client to login to the database as the 'root' user. Try to do a 'select count(*) from....' against the table in question that is marked as crashed. What are the results?
Subject
Written By
Posted
Re: Corruptions like crazy
April 29, 2015 04:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.