On Wed, 1 Mar 2006 22:56:20 -0700 "J M" <[EMAIL PROTECTED]> wrote:
> I'm trying to install mysql-server50. When I did a make install > clean I got an error that said it was looking for the same client > version. I tried to isntall the version 5 client and it is > telling me that I have to do a pkg_delete on the old version (version > 4). I tried that and it looks like koffice, kde and samba rely on > that client and it won't let me delete it. > > What would be the best way to install mysql version 5? Or should I just > stick with 4.1? First of all, get a list of what ports depend on MySQL: # portversion -vr mysql\* | less Then, check *each*and*every* dependent port's Makefile (e.g. /usr/ports/net/samba3/Makefile) and make sure that they will all work with MySQL 5. In general, if the Makefile has the line "WANT_MYSQL_VER=some_number_other_than_5.0", you'll have to stick with 4.1 (unless you're feeling brave). $ cd /usr/ports; grep WANT_MYSQL_VER net/samba3/Makefile \ editors/koffice-kde3/Makefile ... MySQL 5.0 is the latest GA release (for production use). So you may want to consider a *planned* upgrade if you've got data that you want to retain. First, dump out your 4.1 databases: $ mysqldump -uroot -p -A --opt > all-dbs.sql I would also strongly encourage you to back up any configuration files or data for those dependent ports. Then forcefully uninstall 4.1: # pkg_deinstall -f mysql-client mysql-server Now add the following line to /etc/make.conf (if the file doesn't exist, create it as root): WITH_MYSQL_VER=50 Then rebuild your dependent ports. Note 1) that this will likely take a *really* long time, but 5.0 should be automatically built and installed for you in the process and 2) it will forcefully rebuild all of the dependencies (as well as install new dependencies) for net/samba3 kde\*, etc. Backup, backup, backup. # portupgrade -fR net/samba3 kde\* ... YMMV, but I've found that one of the biggest troublemakers in this process are stale configuration files. If you run into problems, try running "make rmconfig" or "make rmconfig-recursive" in the port directory (as root). Finally, set up MySQL (per the documentation), start up the server, and restore your database: $ mysql -uroot -p < all-dbs.sql That should do it. Good luck! -- Anthony Chavez Greater Utah BSD User Group mailto:[EMAIL PROTECTED] http://gubug.org/
pgptyTeoYPQg7.pgp
Description: PGP signature
_______________________________________________ gubug mailing list [email protected] https://gubug.org/mailman/listinfo/gubug
