MySQL Forums
Forum List  »  Data Recovery

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
ALTER column erased table
825
June 29, 2019 06:52PM
466
June 29, 2019 07:15PM
450
June 29, 2019 07:38PM
452
June 29, 2019 09:10PM
466
June 29, 2019 09:57PM
467
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.