upgrading mysql

Michelle tristan11 at mindspring.com
Fri Aug 29 11:56:16 PDT 2003


I would like to upgrade mysql from mysql-server-3.23.54 to 
mysql-server-3.23.57 and understand that I will need to do a dump 
before upgrading since the upgrade needs to overwrite the databases.  
Since I have never done this before, I just want to make sure I have 
the correct steps after reading over the mysql site and the man pages.

First I will dump all of my databases:

mysqldump  -A > backup-file.sql

Then I will shutdown the mysql server and upgrade the mysql port with 
the environment variable OVERWRITE_DB defined when running make install.

To rebuild the databases do I simply use:

mysqldump --all-databases > backup-file.sql

and then restart the mysql server using mysqld_safe

Am I missing any steps?

Thank you,
Michelle


More information about the freebsd-questions mailing list