Date: Fri, 29 Aug 2003 11:56:12 -0700 From: Michelle <tristan11@mindspring.com> To: freebsd-questions@freebsd.org Subject: upgrading mysql Message-ID: <75C451F8-DA52-11D7-8C70-000393843210@mindspring.com> In-Reply-To: <001e01c36e54$164e14f0$6501a8c0@croydon>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?75C451F8-DA52-11D7-8C70-000393843210>