Results 1 to 7 of 7

Thread: MySQL

  1. #1

    Default MySQL

    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

  2. #2
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,442

    Default Re: MySQL

    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!)

  3. #3

    Default Re: MySQL

    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

  4. #4

    Default Re: MySQL

    Are you looking for something like xampp for development and not productivity?

    apache friends - xampp

    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.

  5. #5
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,442

    Default Re: MySQL

    I suggest you join openFATE https://features.opensuse.org/ and put your suggestions directly to the developers.

  6. #6
    Join Date
    Jun 2008
    Location
    Finland, European Union
    Posts
    1,879

    Default Re: MySQL

    Quote Originally Posted by samwootton View Post
    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.
    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.

  7. #7
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: MySQL

    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:

    Code:
            --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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •