Best way to upgrade mysql-server?



Hi,
I recently upgraded from 3.23 to 4.027. My steps were:

1. Stopped the mysql server
2. make deinstall in mysql-server 3.23
3. make deinstall in mysql-client 3.23
4. make install clean in mysql-server 4.0.27
5. Ran the mysql_fix_privilege_tables
6. Started the mysql server again

(and ofcourse backups before step 1)

Things seem to be working fine.

In regards to the existing database files, are there more "correct" ways of
doing an upgrade on a production server?

Also, does anyone have some good advice on optimizing tables, correcting and
speeding up things after an upgrade?

Thanks and best regards,
Andreas
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: how to remove exim4 without removing mysql-server?
    ... >> But my mysql server shouldn't be remove. ... The 'mysql-server' package depends on ... I remove mysql-server and exim4 first. ... Then I type 'apt-get install mysql exim4-base-' ...
    (Debian-User)
  • Re: upgrading mysql
    ... >before upgrading since the upgrade needs to overwrite the databases. ... >and then restart the mysql server using mysqld_safe ...
    (freebsd-questions)
  • Big problems with mysql_num_rows - PLEASE HELP!
    ... MySQL Server is version 4.1.7 (I know I should upgrade, ... Server is Linux ... The largest database in the ... I'm happy to upgrade to 5.x if I know for sure it will ...
    (comp.lang.php)
  • Re: how to remove exim4 without removing mysql-server?
    ... >> But my mysql server shouldn't be remove. ... The 'mysql-server' package depends on ... To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org ...
    (Debian-User)
  • Re: upgrading mysql-server
    ... On 09/06/06 Michael P. Soulier said: ... And it shuts down my mysql server, but does not start it again. ... Should the upgrade not handle this? ...
    (freebsd-questions)