Re: After upgrade vom itools6.5.7 to itools 7 problems mysql

[eyang@xxxxxxxxx (Eric Yang)]

On Wednesday, May 21, 2003, at 05:56 AM, peter polz wrote:

> Hello!
>
> Is it the programm difference between 4.0
> to 3.23 is it better to stay by
> 3.23 for itools7 for the
> upgrade.

Hi,

4.0 provides new features for the database, but if you are running as an update from 3.23,

then you will not be able to use 4.0 features.  You will need to run

/Library/Tenon/MySQL/bin/mysql_fix_privilege_tables to upgrade the database.

Otherwise, MySQL is running as backward compatible mode.

> To you should down mysql over the
> terminal with ps -ax than kill
> ./bin/safe_mysql and
> Library/MySQL/libexex/mysqld

If you have existing MySQL database in /Library/MySQL/var , then you need to move the folder to /Library/Tenon/MySQL/var.

Be careful of the database permission.  The kill command is not be the proper way to shutdown MySQL.  A slight small chance to corrupt your MySQL.  You can shutdown iTools 6.5.x MySQL from /Application/iTools MySQL.app.

The command line method is:

cd /Library/MySQL/bin

./mysqladmin -u root  -p shutdown

I recommend that you shutdown MySQL, and preserve a copy of /Library/MySQL/var.  Uninstall MySQL using installer.sh like this:

cd /Library/Receipts

sudo installer.sh --delete MySQL.pkg

After this, install MySQL for iTools 7.  And move /Library/MySQL/var to /Library/Tenon/MySQL/var.

Run /Library/Tenon/MySQL/bin/mysql_fix_privilege_tables to upgrade the database.

Then you are done.

regards,

Eric

> am 21.05.2003 12:42 Uhr schrieb Terry
> Allen unter hmag@xxxxxxxxxxxxxx:
> > > Hello!
> > >
> > > After the upgrade i have a problem with
> > > mysql from itools6.5.7
> > > The installer for itool7 is unabel to
> > > install
> > >
> > > What is there the problem, should i take
> > > the mysql 3 or mysql 4=3F
> > >
> > > And what is the problme that it did not
> > > go=3F
> > >
> > Hi again,
> > Well, in my update, I had to shut down
> > MySQL first, run the
> > update, then restart MySQL. I did have a
> > problem with my update which
> > Eric from Tenon helped to sort out on
> > updating from MySQL 3.x to 4.x
> > - hope that helps.
>
> ---------
> Tenon Intersystems' iTools Mailing
> List
> To unsubscribe: send mail to
> itools-request@xxxxxxxxxxxxxxx
> with the body only containing:
> unsubscribe
> Find the searchable mailing list archives
> at:
> http://itools.blackpepper.co.nz/                               
>
>

--------------------------------------------------------------------------------------------------

Eric Yang                                                               Senior Software Engineer

Tenon Intersystems                                                                     eyang@xxxxxxxxx

1123 Chapala Street                                                            805-963-6983

Santa Barbara, CA 93101                                             http://www.tenon.com

--------------------------------------------------------------------------------------------------