Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Running two diff MySQL versions at once?
I would like to upgrade my Wordpress. I share the server with other people. Wordpress upgrade will require a MySQL upgrade (from 4.x series to 5.x series). I could upgrade the MySQL, but I fear that would break other people's applications and force them to upgrade as well. So I'd like to run two MySQL, keeping the existing 4.x series for legacy apps and another 5.x series for newer apps. What needs to be done to do this?
1 Answer
- 1 decade agoFavorite Answer
It's not complicated at all.
The main thing is to run them on different ports. When you specify in your applications where to connect for an older version to its regular port, for others - new port.
You also must have different socket, shared memory base, pid file.
If you want logging - make sure they have separate logging files.
so next options must be unique for each instance:
--port=port_num
--socket=path
--shared-memory-base-name=name
--pid-file=file_name
for logging:
--log=file_name
--log-bin=file_name
--log-update=file_name
--log-error=file_name
--bdb-logdir=file_name
Addition:
Here is a good description for both *nix and Windows.