Replacing PostgreSQL with MySQL

[JCrou82]

I currently have RHL 7.?? runing Apache 1.3.12 and PHP 4.0.3pl1 with PostgreSQL installed. I'm not all familiar with PostgreSQL and need to have a PHP DB app running in little time. So I need to uninstall PostgreSQL and install MySQL. I'm also thinking of maybe upgrading my PHP and Apache to go with the newly installed MySQL. The problem i'm having is that, though I can install software on a Linux server, I do not know how to UNINSTALL software or UPGRADE it either. Can someone point me to some online documentation on how to go about improving my server box or point me to some books or tutorials?? I would also like to mention that I'm also running a POP server (don't know which) and Sendmail (don't know version number).

Thanks

 

[RhythmAce]

I can't imagine MySQL not being installed on your version of RedHat. If time is an issue, you should be able to run PostgreSQL and MySQL at the same time. To check if MySQL is installed use the rpm package manager:

rpm -q mysql

If MySQL is installed, rpm will return the version number. To uninstall a package, you would use the -e option:

rpm -e postgresql

I have no clue how to convert the databases. Hopefully it's not much more difficult than dumping one and importing it into the other. To upgrade from RH 7.x to RH 8 or 9, is not a simple one. There are so many differences that it will almost be like changing to another distro. Not only has the file system changed, the directory structure is different too. You will also notice that most of the config files for the servers no longer work. If you are running RH 7.3, you are not alone. It is a very stable version. Unless you are using it as a workstation, there is no real incentive to make the big move.

 

[JCrou82]

RythmAce,

Thanks for your post. I have tried to query the system for postgresql and mysql and it says that it's not installed. I find that a little odd considering I have logged in to postgres (althought that's as far as I could go) so i'm afraid that the command "rpm -e postgresql" won't work.

As for upgrading the OS, I guess i'll leave it alone but I would like to be able to know how to upgrade Apache and PHP at least. The tutorials I've seen assume you know what you're doing within a Linux environment. I've got a general idea but I'm not too comfortable with uninstalling software on the server. So if you know of any good online tutorials.

thanks