Re: Can we delete ibd table without repercussion?
Posted by: Karen Goh
Date: January 08, 2019 04:25AM

Hi Peter,

There isn't any problem. If there was a problem, it is already fixed. Previously, MYSQL sever was working ok and then suddenly it just could not accept the password.

Even though now MYSQL can be connected, the schemas previously created are not there.

So, I'd like to know how to bring in these schemas with the tables already created before the breakdown.

I read about bringing in the tables in a very complicated way via :

https://dba.stackexchange.com/questions/71596/restoring-mysql-tables-from-ibd-frm-and-mysqllogbin-files

etc.

So, I thought the fastest way is just create the schema with different name without importing the tables, since I have the scripts.

In this case, do you suggest I can go ahead and delete the ibd tables or just don't touch them ?

Is there a workaround to bring in the existing schemas ?

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.