Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Other *NIX Forums > *BSD
User Name
*BSD This forum is for the discussion of all BSD variants.
FreeBSD, OpenBSD, NetBSD, etc.


  Search this Thread
Old 10-03-2004, 10:20 PM   #1
LQ Newbie
Registered: Oct 2004
Posts: 2

Rep: Reputation: 0
Upgrade MySQL from 3.23 to 4.0 on FreeBSD with PHP and Apache installed


I would like to do an upgrade on a Virtual Private Server I have with Verio Web Hosting. I want to upgrade MySQL from 3.23.58 to 4.0.20. I tried using:

RPM -qa | grep mysql

but nothing came through. I logged on as "root" and still nothing came out.

So what's the best way to do this upgrade without interrupting the service for long? (20-30 minutes of downtown is OK, but not more)

I am willing to use RPM. My current database has 8 databases and over 50 tables all of which are MyISAM type.

I have PHP 4.3.9 and Apache 1.3.31 isntalled on the server.

thanks for all your help :-)
Old 10-06-2004, 11:44 PM   #2
Senior Member
Registered: Jul 2003
Location: Silicon Valley, USA
Distribution: OpenBSD 4.6, OS X 10.6.2, CentOS 4 & 5
Posts: 3,660

Rep: Reputation: 69
Umm, FreeBSD does not use RPMs, it uses the ports/packages system. You should be able to get the newest port of MySQL by updating your ports tree. You could also download the latest package and install it that way.
Old 10-07-2004, 10:59 AM   #3
LQ Newbie
Registered: Oct 2004
Posts: 2

Original Poster
Rep: Reputation: 0
Thanks Chort :-)

That's odd! Why is the RPM package installed on my system then? That was confusing.

I was able, with the help of Verio's tech support, to upgrade from MySQL 3.23.58 to 4.0.20. The only we got it to work was to uninstall MySQL server and client packages using the "pkg_delete" command and then using "vinstall" utility that comes with Verio's Virtual Private Servers.

To know what packages to delete, I typed in:

$ pkg_info | grep mysql

This showed all packages installed on the system that had the string "mysql" in their name and their versions. When I started deleting those packages, I encountered some errors due to dependent packages. Uninstall those as well.

After uninstalling the old MySQL, I used "vinstall" utility to install the new one. When I was done installing MySQL 4.0.20, I typed the following commands and it was free sailing from there:

$ rehash
$ mysql_fix_privilege_tables

That was it :-)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i Know Apache PHP MYSQL Installed on my Dedicated Server? phpsharma Linux - Newbie 3 04-18-2005 05:40 PM
Apache, MySQL and PHP with FreeBSD? Mega Man X *BSD 9 01-24-2005 05:08 PM
installed apache, mysql -- help with php machiner Linux - Software 2 07-28-2004 01:36 PM
How do I know that apache, MySql, PHP, phpMyAdmin is Installed AskMe Linux - Newbie 7 02-04-2004 05:27 PM
Linux 8.0 installed with Apache 2.0, PHP and MySQL fmagoufis Linux - Newbie 1 12-12-2002 01:13 PM > Forums > Other *NIX Forums > *BSD

All times are GMT -5. The time now is 04:04 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration