Hi hope somebody can help me. I was changing around some tables in a DB that was working fine.I don't know what I did but I deleted a table and wanted to recreate it a little different.Now I cannot do it, I get a message that the table already exists.So I checked the data file and saw that infact there is an ibd file for that table.I try to delete it and get a message that I cannot do it because the file is open in mysql 56? I tried to rename it and just leave it there and recreate the table I need with its proper name.Niet.I tried to delete the whole DB, cannot do it. Should I uninstall mysql? Will that solve the problem?What else is there to do? Thanks for your help.

Member Avatar for LastMitch

Should I uninstall mysql?

@Fiorentino01^

I will hold off on that for now. Why did you change your table structure?

Who taught you to do that way?

Post your errors.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.