PDA

View Full Version : MySQL 5? or 4?


TakeIT2
10-1-07, 02:08 AM
I could be mistaken but my php-info test page is reporting that the version of MySQL running on the server is version 4.1.11 !

I was told the server (mysql12) was upgraded MySQL 5 completely Aug. 13th.
see : http://www.powweb.com/info/systemnotice.bml?id=3741

I have been reading a lot of the mysql threads seeing what folks are saying about server issues. There seem to be a lot of different reasons at different points.

I have a new difference.
I just installed WordPress 2.3 and a gallery plugin that reports the MySQL version as "5.0.41-log" Now, the WordPress install is pointing like username.mysqlpowweb.com so maybe it is getting it's version number direct from the database server, the half page of phpmyadmin that loads reports the same mysql version. But php/apache? itself is reporting something wholly different version 4.1.11 !

(phpMyAdmin also reports the server name as custsql-pow12- ) someone suggested just getting an outside database, another commented that it is better for apache/mysql to reside on the same server - (with all the aliasing and migrations, upgrades, and restores, [some are not as transparent/done without notice] ...does anybody else think it might be time for a fresh setup? A clean install? a direct approach?

All the handshaking and passing off from one system to the next to preserve the old order of something, at this point I am not sure of what, because ops didn't even retain my personal info... (irregardless, the pertinent data was retained usr/psw, credit card info and domains, db-backup and disk files) That said, why not just go all the way and build a structure that works and reports accurately.

The way it is now we are all left guessing, waiting for intermittent interruptions ,failures, for causes that might be shared and for which we have no control, and that goes for the admins too. The system is out of control - and it makes me wonder if the system automation is running the asylum.

TakeIT2
10-1-07, 02:23 AM
oh and I get that the mysqul is on a different server than apache/php that seems obvious

dmacminn
10-2-07, 12:00 PM
The PHP Versions are 4.4.4 or 5.2.1 (PHP is part of CGI and Scripted Language System)
And thats the PHP MySQL Client API version 4.1.11 (the piece of PHP that talks to MySQL)
----
In your Ops, Main, WebSiteManangement Area - Server Information it should probably show:
MySQL Version 5.0.45

And, if you login to a MySQL database and select "Variables" -- the basedir should be pointing to something like "/usr/local/mysql-5.0.45-linux-i686/" which means you're running from the mysql-5.0.45 copy of MySQL on the server.

Essentially everybody is operating on MySQL 5.0.n at this point... (a few servers did run 5.0.41 for baseline/testing purposes)