?
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
Medium Priority
?
209 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

719 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