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 [EMAIL PROTECTED] _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"