On a linux box you do not have to stop everything like on Windows. We always leave our current version running, install the upgrade in a new location with a new data dir (a snapshot of the live one). We run the new install on a different port than the live install so we can test it and what not before switching over. We always leave our installs in a directory that gives the version info like mysql-3.23.55-pc-linux-i686 and then symlink a directory named mysql to the version that should be live. So when we decide it is time to go live with the new install we change the conf to point to the correct data dir and to be on the right port, stop mysqld, change the symlink and then restart with the new version. This allows for easy rollbacks just in case.
We have had really poor luck with building from source on our VA Linux box and have used the binaries for the last two or three upgrades. Our builds were really unstable and buggy under a high load, but the binaries have been great. Hope that helps -----Original Message----- From: Tab Alleman [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED] wrote: > Can someone help > point me in the right direction? Thanks I just finished a practice upgrade (on a back-up server) myself and will be upgrading the real server during off-peak hours soon. We are running win2k servers so I can't speak directly to any linux issues, but generically speaking, upgrading to 3.23.56 was easy: I downloaded the installation files to my server and unzipped them. Stopped the MySQL service AND mysqladmin (you will have errors if you don't do this!). Then ran the setup.exe, restarted the service, checked mysql admin and saw that the version had been updated, and smiled. I would imagine if you follow the corresponding linux-steps, you should have no problems. Good luck, Tab mysql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
