Timeline for Data in one or more tables corrupt after recovering tables with alter table discard/import tablespace
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 28, 2022 at 3:45 | comment | added | Citizen1138x | The length of varchar() columns on all tables were anywhere up to 8 times their original values. Typically 3x. All tables were affected. Only the games table had the corrupted data. I wrote some code to fix it all. The schema appears to have changed from utf8 to latin1, which I have fixed and gone through and changed all tables to utf8. I don't know why the games table had corrupted data or why everything changed to latin1 and I haven't found a way to resolve the problems or why columns were expanded. After repairing the data and checking things everything appears to be fine now. | |
| Apr 27, 2022 at 11:37 | history | edited | J.D. |
edited tags
|
|
| Apr 27, 2022 at 4:42 | history | edited | Citizen1138x | CC BY-SA 4.0 |
Added CREATE table statement
|
| S Apr 27, 2022 at 4:36 | review | First questions | |||
| Apr 27, 2022 at 14:40 | |||||
| S Apr 27, 2022 at 4:36 | history | asked | Citizen1138x | CC BY-SA 4.0 |