Home / server / Questions / 28949
Accepted
Darryl Hein
Asked: 2009-06-20 13:21:32 +0800 CST

Should I expect problems with a different version of the MySQL PHP extension vs the MySQL server?

  • 772

I have a server that has a PHP MySQL extension version 5.0.77 while the MySQL version is 5.1.34. Some pieces of software/scripts are warning me that I may have problems.

What kind of problems should I expect and should I be concerned about it? (I'm not running any fancy MySQL queries/commands through PHP.) Is it big deal?

We don't feel like recompling PHP with a newer version of the library and the server admin really had no idea how (although I could probably figure it out).

mysql php

1 Answers

  1. Best Answer

    The kind of problem that I would be worried about in that situation -- assuming a superficial test showed that I was at least able to perform some basic queries -- is differences in the handling of obscure corner cases in the application protocol. That is, the kind of thing where you run fine for a month and then some idiosyncrasy of network behavior tickles the problem and things get weird. Just because you don't do anything fancy with MySQL doesn't mean you're safe. It could be that nothing would go wrong, but I certainly wouldn't feel secure running with that mismatch.

    If you try it, you should try to make arrangements so that something or someone will remind you that this is the case if you start having weird application failures.

    • 1