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]

Reply via email to