Hi, is there nobody interested in multiple mysql databases on 1 system? Op Sunday 17 February 2008 15:11:09 schreef Richard Bos:

Hi,

anybody out there that want to test a new mysql rpm, that supports the start of multiple databases during system startup (and stop during shutdown)? The new startup script, should become part of openSUSE, but it needs some testing, before the script can be integrated.

The rpm and it's dependencies can be retrieved from this repository: http://download.opensuse.org/repositories/server:/database:/mysql51/openSUS E_Factory/repodata/ http://download.opensuse.org/repositories/server:/database:/mysql51/openSUS E_10.3/repodata/

The /etc/init.d/mysql script has 2 legs: - 1 with code that is currently in use (so there is no change in the startup script behaviour) - and a leg with the new code, that starts and stops multiple databases

With a variable in /etc/sysconfig/mysql (or in the sysconfig editor Applications/Mysql) one can select which leg to use. To use the new code the variable MYSQLD_MULTI has to be set "yes".

The code to start the multiple databases uses mysqld_multi that comes with the mysql code to start the databases.

Databases can be added using the databases sections at the bottom of /etc/my.cnf

Looking forward to test reports!

-- Richard Bos We are borrowing the world of our children, It is not inherited from our parents. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org