Re: IBMDB2I Storage Engine Question

[Mike Pavlak <mike.p@xxxxxxxx>]

And, while MySQL is not "actively" supporting MySQL for IBM i, the downloads are still available on their archive site.

http://downloads.mysql.com/archives.php?p=mysql-5.1&o=i5os


Mike

mike.p@xxxxxxxx   Cell: (408)679-1011    Office: (630)928-1476

Zend Server for IBM i available at http://www.zend.com/en/products/server/zend-server-5-new-ibmi 

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Matt Lavinder
Sent: Thursday, May 12, 2011 2:55 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] IBMDB2I Storage Engine Question

> First point - the storage engine is still _owned_ AND _supported_ by IBM.
The only thing that has changed is that Oracle are
> no longer distributing binaries of MySQL for IBM i and AIX. period - end
of story.

Sorry about that misstatement.  Since I have been looking into MySQL and the
storage engine today, I had actually figured this out for myself.  I
definitely know more than I did this morning (and obviously still learning).
I was looking at the storage engine and MySQL as being the same thing, and
they are definitely two separate things.

> Just as a follow up - based on the information that I mentioned earlier,
Bob Bergstrom was able to move his MySQL data without reinstall etc.

I might try that.  I am just getting started with MySQL for IBM i (though
have used it quite a bit in Windows and Linux).  Updating or reinstalling
isn't something I am too concerned about doing at the point, but thanks for
the instructions.  Definitely helps me understand the problem and gives me
some options.


On Thu, May 12, 2011 at 3:13 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

> Just as a follow up - based on the information that I mentioned earlier,
> Bob Bergstrom was able to move his MySQL data without reinstall etc. Here's
> the step by step instructions that he came up with:
>
> CALL QP2TERM
>
> mkdir -p /QOpenSys/usr/local
>
> cd /usr/local
>
> mv mysql-5.1.35-i5os-power-64bit /QOpenSys/usr/local
>
> mv mysqldata /QOpenSys/usr/local
>
> ln -sf /QOpenSys/usr/local/mysql-5.1.35-i5os-power-64bit mysql
>
> ln -sf /QOpenSys/usr/local/mysqldata mysqldata
>
> modify /etc/my.cnf to reflect directory changes.
>
>
> Jon Paris
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.