How do i go about deleting a mysql instance, and rename another mysql instance to take its place.
I have two instances of windows mysql running. mysql, and mysql56. I want to delete mysql and just rename mysql56 to mysql. Recommendations? I have very little sql or mysql experience.
Right now the mysql instance fails, and wasn't fully setup when i screwed it up. I had a .sql script which didn't run correctly and hosed something up. The secondary mysql56 instance however is setup with the .sql script correctly and picked up all the correct tables and even seemed to merge properly from another database. I don't want to try to save the original mysql instance, i just want to get the new mysql56 going.
Further info, i have mysql instance with database thinmint. I have mysql56 with that same database in it as well. That is the only database that matters to me...I think i have a test database and whatever came with the original mysql setup.