Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
Im after some help if possible.
I have a critical web application which is currently running on MySQL 5.0
We have a few issues and have been advised that updating to the latest (5.6?) would be a good thing to do.
From what I've read, newer version of 5.x should be fine for the most part, but the newer versions are more sensitive to bad bracketing in join queries.
Is there an easy way for me to test my web application other than manually installing something like IIS/Apache, PHP and MySQL?
Im not familiar with setting any of that up and I don't really want to go through the rigmarole if there's an easier way
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
IIS & PHP is a lot easier now. Microsoft give you the option to install it from IIS.
Or you could install WAMP that has it all built in a copy the DB etc to the new instance and test that way. I would hope its just the one config in the web app to change the connection parameters
|
Nismo
Member
Registered: 12th Sep 02
User status: Offline
|
Yes the easy way is a package installer.
http://www.apachefriends.org/en/xampp.html
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Not really sure how brackets in queries can be interpreted in different ways 
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
James, the comment passed back was;
quote:
The VDS is running quite an old MySQL version now (5.0) and newer MySQL versions are more efficient in all kinds of places, so the first suggestion I'd have is to update the version. Perhaps you could test it locally first though to see if it's a) worthwhile and b) compatible - although I've not seen any issues with moving from 5.0 to newer versions, with one exception - bad bracketing in join queries which 5.0 accepted but 5.1 does not.
Does it sound entirely possible?
Thanks for the link Nismo, I will probably give that a try.
[Edited on 02-10-2013 by Bart]
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
quote:
Originally posted by James
Not really sure how brackets in queries can be interpreted in different ways
Syntax is stricter in later versions so they won't run if there's any ambiguity.
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
I will obviously test this, but what do you think the likely hood of there being a problem?
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
quote:
Originally posted by Bart
I will obviously test this, but what do you think the likely hood of there being a problem?
Depends if the original developer did the queries correctly and that, no one knows. Unless the app is horrendously complicated then it shouldn't take too long to get it up an running under a test environment.
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
Thanks for the link Nismo, really is a piece of pish with that installer and just a one click to enable everything.
|
