ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Pb upgrading MySQL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pb upgrading MySQL

    Hi all !

    On our i5 V5R4, I've installed PHP Zend core distribution wich includes MySQL.
    It works pretty well, but... :
    MySQL is at level 5.0.45 and I would like to use the new " IBM DB2 for i as a Storage Engine of MySQL"
    So I read the redbook : Using IBM DB2 for i as a Storage Engine of MySQL and this web page
    --> MySQL 5.1.xx is required

    So, I installed all required PTFs, and started Mysql 5.1.37 installation.
    During execution of the command MYSQLINST/INSMYSQL I get the following message :
    Code:
    15: Configuration file can not be created.  /etc/my.cnf file already exists!
     Press ENTER to end terminal session.
    The full install.log is :
    Code:
    Installation started at: Tue Aug  4 13:29:35 Europe Centrale - Heure d'{t{ 2009
    /QOpenSys/usr/local/mysqldata
    /QOpenSys/usr/local/mysql
    
    Extracting tar file for installation.
    Create new symbolic link to the MySQL installation.
    Changing ownership of the installation directory to the MYSQL user.
    15: Configuration file can not be created.  /etc/my.cnf file already exists!
    Precisions :
    - I ran the command MYSQLINST under a true QSECOFR session
    - I tried to change session CCSID to 37 (sysval QCCSID is 297), but the result is the same
    - I stopped MySQL daemon and MySQL subsystem using ZCMENU options.

    What am I doing wrong ?

    TIA
    -
    Jean-Michel

  • #2
    Re: Pb upgrading MySQL

    Have you tried deleting /etc/my.cnf and running again?

    Comment


    • #3
      Re: Pb upgrading MySQL

      Yes I tried.

      But it stops at a next step : it says something like

      "Unable to create core MySQL database (already exists). "
      Jean-Michel

      Comment


      • #4
        Re: Pb upgrading MySQL

        you might want to register here with IBM/Zend to access some experts..




        jamie
        All my answers were extracted from the "Big Dummy's Guide to the As400"
        and I take no responsibility for any of them.

        www.code400.com

        Comment

        Working...
        X