Solved

How do i go about deleting a mysql instance, and rename another mysql instance to take its place.

Posted on 2014-12-12
1
190 Views
Last Modified: 2014-12-15
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.
0
Comment
Question by:CoffeeBlack
1 Comment
 

Accepted Solution

by:
CoffeeBlack earned 0 total points
ID: 40496995
delete the old instance (from services):
sc delete MySQL (note from cmd or command with admin, not from ps)

Then from what i've searched for seems to state that i'm going to need to create a new schema/instance, export the database out of the old mysql isntance and import the database in to the new schema.  This sound about right?

edit: importing to the new instance worked for me, though it sounds like it doesn't work for everyone.  I did make some permission changes in order for it to work, including removing old permissions and adding in new ones (even when they were the same names);
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question