Date: Fri, 29 Aug 2003 15:19:35 -0500 From: "Jack L. Stone" <jackstone@sage-one.net> To: Michelle <tristan11@mindspring.com>, freebsd-questions@freebsd.org Subject: Re: upgrading mysql Message-ID: <3.0.5.32.20030829151935.01394798@sage-one.net> In-Reply-To: <75C451F8-DA52-11D7-8C70-000393843210@mindspring.com> References: <001e01c36e54$164e14f0$6501a8c0@croydon>
next in thread | previous in thread | raw e-mail | index | archive | help
At 11:56 AM 8.29.2003 -0700, Michelle wrote: >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 I posted this just a few hours ago..... Use portugrade and its easy. It is a simple one-line command on FBSD-4.x: # portupgrade -m '-DSKIP_INSTALL_DB' mysql-server-3.23.54 Best regards, Jack L. Stone, Administrator SageOne Net http://www.sage-one.net jackstone@sage-one.net
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3.0.5.32.20030829151935.01394798>