Jay, mysqld_multi will do what you want, it's a tool to help you manage
two or more mysql daemons on the same host. You can either have the two
databases bind to different IPs or same IP and different ports.
To the other replies in this thread: why wouldn't you want to have
development databases
I'm setting up our one server for staging and development. I am need to set
up MySQL to have 2 copies of the same database on the same server. Could
anyone direct me to some documentation or tell me how to do this?
Thanks.
--
MySQL General Mailing List
For list archives:
I'm setting up our one server for staging and development. I am need to set
up MySQL to have 2 copies of the same database on the same server. Could
anyone direct me to some documentation or tell me how to do this?
Is there a reason you can't have one instance of the mysql server and
simply
Jay Paulson wrote:
I'm setting up our one server for staging and development. I am need to set
up MySQL to have 2 copies of the same database on the same server. Could
anyone direct me to some documentation or tell me how to do this?
Thanks.
What's wrong with having a test and production