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

Written By
ALTER column erased table
June 29, 2019 06:52PM
June 29, 2019 07:15PM
June 29, 2019 07:38PM
June 29, 2019 09:10PM
June 29, 2019 09:57PM
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.