Hi,
Recently installed opensuse.
I would like to install a new version of MySQL - and not use the one that comes installed through Yast by clicking.
How do i “shut-off” or remove completely all MySQL references / processes / files - so that i know my install is not being effected by any original MySQL install.
Its hard to know what parts are my install and what parts are the old install.
Thanks for any help.
Regards, Sam
This is not recommended because the version you get through YaST has been tailored for openSUSE and, as you have suspected, even if you asked YaST to uninstall it, that would not restore all the configuration files to their original state.
You would be much better waiting for 11.2 and installing the new version then. (Back up your existing databases before you do that, of course!)
Hi john_hudson,
Thanks for the reply.
What i don’t like about default installations, is that the software is distributed/scattered all over the place.
For example, i have reinstalled my own version of Apace2 - and its all neatly in 1 dir, nice and orderly and easy to move around in. And i really wanted to do the same with MySQL.
I feel it kind of goes against my linux thoughts - i don’t want to be restrained by a previously installed version - i would like my own clean / single location copy.
Is there now way to do this (easily?).
I’ve done Apache, now MySQl, then on to Tomcat. You see i had a motherboard melt on an old server - and i would like the same set-up.
Thank you for your time and help.
Regards, Sam
Are you looking for something like xampp for development and not productivity?
I think it installs all of them in /opt/lampp
For a newer version you could always look on Software.openSUSE.org there is a repo for it.
To see which files come from the “original” suse rpms just use yast and “show files” of the installed packages.
Of course, the better way would have been to uninstall suse mysql first before install your own.
If you just used a pre-built binary from mysql website as it is documented for example here all of your new mysql install should be in it’s own directory where you extracted the tar archive so I suppose you could safely remove the suse package. If you go on this road, I think you’ll have to read the documentation, for the other utilities if you need them, e.g. to set the environment variables, etc.
One final note: I really can’t see the “tidy” of your mysql install since you wonder which file came from where. Also I guess it will be a lot of work to set-up the system scripts but if it suits you…
Cheers.
I suggest you join openFATE https://features.opensuse.org/ and put your suggestions directly to the developers.
And in a week your system will be swiss cheese because you’re running out of date applications.
The Apache layout on SuSE is great and designed for true server environments where you don’t keep “all eggs in one basket”, which is a vast improvement over the “hey, I got a 200kB httpd.conf”.
Running XAMPP has the same problem - if you don’t let the distribution patch the files for you, you’ll eventually run into two possible issues; your system has unpatched software that Mr. AutoBot will use to cruise in and eventually you’ll run into incompatibilities with other components.
But hey, what would I know.
Hi Sam,
I would like to install a new version of MySQL - and not use the one that comes installed through Yast by clicking.
I did exactly this several times, because I need the same MySQL version on different hosts to avoid replication issues. The procedure was basically: - backup data / uninstall MySQL with yast / compile new MySQL from source / install.
The key point is to tweak configure to select exactly the same directories as used by SUSE. The relevant part of my options for configure was:
--infodir=/usr/share/info \
--libdir=/usr/lib \
--libexecdir=/usr/sbin \
--localstatedir=/var/lib/mysql \
--mandir=/usr/share/man \
--prefix=/usr \
--sysconfdir=/etc \
--with-mysqld-user=mysql \
--datadir=/usr/share \
--includedir=/usr/include \
I never encountered any problems, but ymmv.