PostgreSQL, MySQL and PHP in CPanel

Hi, I am not a service provider, I don't know anything about CPanel, but I have question about the above:

1: How difficulty is it to upgrade MySql from CPanel?

My problem is: I bought a resell account, server's MySql version is MySql 3.23.53a, however, when it was complied, it didn't include the max option, so it means no transaction support, no Innodb, no BDB support (I tried SHOW VARIABLES LIKE '%HAVE%' on MySQL terminal, only shows "have_isam YES", others are just NO). So I asked my provider to install mysql with max option, this was what I got from him:
Unfortunately we cannot offer innodb or bdb support this time. CPanel comes with mysql binaries which we have no control over the compilation process

So I am wondering how difficulty is it to reinstall/upgrade MySql from/beyond CPanel?

2: If php was compiled without pgsql (postgresql) support, how difficulty is it to make the PHP to support pgsql functions?

Since I want transaction support, thus he installed PostgreSQL 7.3 for me. However, I checked on php.net, it says PHP must compiled with pgsql option in order to support pgsql (and I checked my phpinfo(), it was NOT complied with pgsql), or to use dl() function to load the dynamic moudle (I checked extensions directory on my server, no available moudles there). So I'm wondering if php was compiled without pgsql (postgresql) support, how difficulty is it to make the PHP to support pgsql functions?

3: If question 2 is too difficulty or impossible (I believe it is possible), so what is alternative way to access PostgreSQL database in my PHP code?

I think PEAR also uses php built in functions pg_*, so PEAR is not the alternative to do so, am I right?


Thanks!

 

 

 

 

Top