Re: IBMDB2I Storage Engine Question

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.