Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

MySQL 3.23.45 fixes shutdown problem UNIX
One of the big problems that anyone who wants to use MySQL on OS X faced until now was the inability to safely shutdown the MySQL daemon. Version 3.23.45 was released in the last day or so and fixes this long-standing bug. More information on the changes since the previous version can be found here.

I've downloaded and compiled this version from the source code using some pretty standard configuration options (see below for what I did) and everything appears to be working wonderfully.

Here's the breakdown of my configuration options:
./configure 
--enable-assembler
--prefix=/usr/local/mysql
--with-named-z-libs=/usr/local/libz.a
--with-innodb
--with-mysqld-user=mysql
Then just run the make and make install commands to compile and install the new binaries. I suspect Marc Liyanage will shortly post a precompiled binary installation but if you're somewhat impatient like me, you can always go this route.

As always, more information can be found on the MySQL website.
    •    
  • Currently 3.00 / 5
  You rated: 1 / 5 (2 votes cast)
 
[4,466 views]  

MySQL 3.23.45 fixes shutdown problem | 4 comments | Create New Account
Click here to return to the 'MySQL 3.23.45 fixes shutdown problem' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Shut-down fixed....?
Authored by: morten on Nov 26, '01 08:44:37AM

Hmmmm....not on my server it isn't (10.1.1, 5M28). running MySQL 3.23.45, InnoDB:

./configure
--enable-assembler
--with-innodb
--with-mysqld-user=mysql

and "mysql.server stop" gives me :

Killing mysqld with pid 358
Wait for mysqld to exitc
.c
.c
.c
.c
.c


Sorry.



[ Reply to This | # ]
Shut-down fixed....?
Authored by: scottboms on Nov 26, '01 10:44:07AM
Try running this command instead. I've now tested this on two machines (a pismo Powerbook G3 500MHz running OS X 10.1.1 and a G4 dual 533MHz running OS X Server 10.1.1) and it works fine on both.

cd /usr/local/mysql/bin
./mysqladmin -u root -p shutdown

You'll be asked to enter your admin password (provided you've set one) and it will shutdown the daemon.

[ Reply to This | # ]

Still awaiting cigar...
Authored by: Anonymous on Nov 26, '01 06:31:17PM

All seemed to go well although there were a few errors at the end of make and make install. The result was a mysql installation that had no scripts or var folders. Removing all and starting from the proper binaries resulted in an installation for which the 'user' table was read only- not even root could change it! I must be going astray somehow...any ideas?
Thanks for the tip!

Tim



[ Reply to This | # ]
Additional Suggestions for Resolving Problems...
Authored by: scottboms on Nov 26, '01 09:54:10PM
What did you use as your configuration when you were compiling MySQL? I was using a static z-library as opposed to the one Apple supplies. you should be able to get this from Forked.net here. If all else fails, then I can post the version I am using on my iDisk.

Beyond the configuration commands I used, there's not much else to it. You should just next run the make and make install commands. Then when that's all done, do the following.

first, create a new user with a short-name of "mysql". Use a long-name like MySQL Admin or something. Then run the following Terminal commands as below.

chown -R mysql /usr/local/mysql/var
cd /usr/local/mysql/bin
./safe_mysqld &
If all goes well, you should have it up and running. Don't be too surprised if you do see a few errors, but everything should still work as expected. Good luck.

[ Reply to This | # ]