Hi,

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 :-)

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.

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 :-)