On Wed, Feb 18, 2004 at 11:12:19AM -0600, Chris Fossenier wrote: > I am planning a server upgrade and would like to update MySQL in the > process. The preferred plan is to: > > 1. Upgrade the server Operating System. > 2. Copy the MySQL files to the new storage system. > 3. Install MySQL 4.0.18 and point it to the old MySQL directory > 4. Start 4.0.18 and have no problems. > > I'm guessing it's probably not that simple. Any insight into this from > someone with experience would be appreciated.
Depending what step #1 really entails, it should be that simple. My normal MySQL upgrade routine is: 1. get/build new mysql 2. install into /path/blah/mysql-version 3. update /path/blah/mysql symlink to mysql-version 4. stop mysql 5. start mysql That typically results in < 5 seconds of downtime. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 157 days, processed 1,904,372,591 queries (139/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]