When googling the error I'm getting I get 5 results back off of asian websites. I'm able to read some of the english off of them but not enough to figure out what they are saying.
When typing in...
portversion -vr mysql\* | less
...I'm getting the error...
portversion: Command not found.
I thought that maybe that the portversion command was in /usr/ports/sysutils directory but all I see are...
port-authoring-tools
port-maintenance-tools
portbrowser
portmanager
portsman
portsnap
portupgrade
When I tried to do pkg_add -r portversion I got...
Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.0-release/Latest/portversion.tbz : File unavailable (e.g., file not found, no access)
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.0-release/Latest/portversion.tb z' by URL
Am I having all these problems because I'm on FreeBSD 6.0? Should I downgrade to 5.4? Since I'm new to any sort of *nix operating system I'm going off limited knowledge so please try not to laugh too hard at my questions. =)
John
On 3/2/06, Anthony Chavez <[EMAIL PROTECTED]> wrote:
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/
_______________________________________________ gubug mailing list [email protected] https://gubug.org/mailman/listinfo/gubug
