ALTER column erased table
Posted by:
Sam Drost
Date: June 29, 2019 06:52PM
I attempted to change a MEDIUMTEXT field to a JSON field, and my table now is gone. I looked at the data folder and there are two sets of .frm and .ibd files "#sql2-28d0-51" and "#sql-28d0_51".
I tried to recreate the table and import both of the ibd files using discard and import tablespace, but the table is still gone.
This is my first time using MySQL. I did not know how to make backups before, so I hope the data is still recoverable.
Subject
Views
Written By
Posted
ALTER column erased table
735
June 29, 2019 06:52PM
424
June 29, 2019 07:15PM
400
June 29, 2019 07:38PM
409
June 29, 2019 09:10PM
422
June 29, 2019 09:57PM
422
June 30, 2019 09:02PM
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.