"Hey guys, just went through a nightmare with one of my MySQL setups and I'm hoping some of you can help. I upgraded from MySQL 8.0.28 to the latest 8.0.31, and now I'm seeing table corruption and queries returning inconsistent results. Anyone else encounter this issue or know of a fix?"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
"DB Nightmare: Table Corruption After Upgrade to Latest MySQL Version"
- Thread starter justen
- Start date
californiusis
Member
- Joined
- Nov 28, 2017
- Messages
- 5
- Reaction score
- 0
"Yikes, table corruption is a real pain! Have you tried running a check on the database with `mysqlcheck` or `mysqldump --quick` to see if that reveals the issue? I've had similar problems with upgrading from v8 to v8.1, and a DB reset often ended up being the solution"
Voldemar2009
New member
- Joined
- Jan 20, 2009
- Messages
- 2
- Reaction score
- 0
What's your take on strategies?
"Yikes, table corruption after an upgrade is a total pain. Have you guys tried running a MySQL check table to see if it's an issue with the data or the upgrade process itself? Also, did you update from a major version or just a patch update?"