Can we delete ibd table without repercussion?
Posted by: Karen Goh
Date: January 07, 2019 08:37AM

I managed to 'revive' MYSQL server to accept the password.

The problem is that I can't import in the table.

And the schema is still there in the ProgramData Data folder.

C:\ProgramData\MySQL\MySQL Server 8.0.13\Data\projectName\tutor.ibd

I learnt that there is a complicated way that one can import in the table but I do not want to try that.

My question is can I simply delete the ibd files inside the Data folder and re-create the schema with the same name without any 'repercussion' ?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.