Mike London wrote:Would appreciate any suggestions.
Mike London wrote:Would appreciate any suggestions.
Roel De Nijs wrote:
Mike London wrote:Would appreciate any suggestions.
And here you'll find the MySQL documentation about Database Backup Methods. It even has a section about what to do if a MyISAM table has become corrupt...
Mike London wrote:It will be a pain to mysqldump all 10 or so databases, re-install, and "hope" I can restore them successfully.
Roel De Nijs wrote:
Mike London wrote:It will be a pain to mysqldump all 10 or so databases, re-install, and "hope" I can restore them successfully.
Best of luck! I'll keep my fingers crossed Keep us posted on your progress or any possible new issues.
Mike London wrote:I ended up re-installing MySQL and that fixed everything. Not sure how the mysql database itself had corrupted tables from the last install, but it's all working now.
Roel De Nijs wrote:
Mike London wrote:I ended up re-installing MySQL and that fixed everything. Not sure how the mysql database itself had corrupted tables from the last install, but it's all working now.
Glad to hear re-installing MySQL did the trick Have a cow for coming back and sharing your solution.
Mike London wrote:I think what happened is that when I copied the data directory directly to the new 5.7.11 data folder from the 5.6 data folder, and that caused a problem. I believe that MySQL changed how they handle passwords (OLD_PASSWORD() now seemingly gone, for example). Possibly something else changed too.
Roel De Nijs wrote:
Mike London wrote:I think what happened is that when I copied the data directory directly to the new 5.7.11 data folder from the 5.6 data folder, and that caused a problem. I believe that MySQL changed how they handle passwords (OLD_PASSWORD() now seemingly gone, for example). Possibly something else changed too.
It seems there are a bunch of incompatible changes when upgrading to MySQL 5.7 (and some of them are indeed password related).
Consider Paul's rocket mass heater. |