Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am setting up a web staging environment and want to have a duplicate but separate MySQL service on the same machine. Development environments will connect to one service and staging environments will connect to another. This way when setting up a staging environment, I don't need to change database names, just the port on the MySQL server I connect to.

Is this easy and possible? I plan on manually copying the databases over to the staging environment when ready.

share|improve this question
This was ultimately what I ended up following: – Kirk Ouimet Nov 29 '10 at 20:42
up vote 0 down vote accepted

Yep. It's easy and possible if i understand your problem correctly.

Only use the tool that Mysql developed for this

Instance Manager

Only one thing. U can't share the databases between the 2 instances in an easy way. Seems that the server "blocks" the files it's use and the database files too. But maybe there's a workaround for that. I dont know it.

share|improve this answer
Do you know why they removed it in MySQL 5.5? That seems that a weird thing to remove. – Kirk Ouimet Nov 29 '10 at 15:52
@Kirk Well, Have no idea. We use it in Windows, and the management tool is show as a "part" of the tray monitor. Get a lock at this… – Carlos Garcia Nov 30 '10 at 11:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.