PDA

View Full Version : Backward Compatibility of MySQL5

iandsmith
8-27-07, 06:50 AM
Don't lose the backup of your version 4 database. Other hosts are on 4. Just a word of warning.
HalfaBee
8-27-07, 08:16 AM
Some hosts are moving forward too.
iandsmith
8-27-07, 10:19 AM
Has anyone anything constructive to say regarding how I switch back to 4 if I want to move host?
entrecon
8-27-07, 01:17 PM
I believe it was mentioned in a post by a staff member that if you HAD to be switched back to 4 they would look to do that on a case by case basis. You might be able to present your case to support and get migrated back long enough to make a back-up.
HalfaBee
8-27-07, 09:27 PM
You will also only have 1 month to fix the issues with your scripts.
So don't just get moved and think everything is ok now.
iandsmith
8-28-07, 02:16 PM
You will also only have 1 month to fix the issues with your scripts.
So don't just get moved and think everything is ok now.

I did it. It must be easy to switch hosts if I can do it.
YvetteKuhns
8-28-07, 02:29 PM
If you move to another web host that still runs MySQL4, eventually even that host may upgrade to MySQL5. It will give you time to update your scripts or try new ones.
dmacminn
8-28-07, 03:36 PM
Development Support for MySQL V4.x with MySQL AB will end at the end of this year -- obviously there will be security fixes for a while, but 5 is where everybody will be headed by the end of the year or early into next...
YvetteKuhns
8-28-07, 03:41 PM
I really didn't see much of anything that worked in version 4 that would not work in version 5. If there is a problem now, there may have been a problem before, the database was corrupt, the database name or login is incorrect or there is a server issue that can probably be fixed.

Most of our sites have already been through the upgrades. I didn't see any of the problems described here, just a few flaky things from the transfer of data in the databases or transfer of files. They were easily fixed.

If anyone has a problem, they should search this forum or Google. Other people have been through the updates and probably solved similar problems.
coldhead
8-29-07, 01:45 AM
upgrading-from-4-1.html (http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html)
YvetteKuhns
8-29-07, 09:48 AM
I would much rather hear from the horse's mouth than the horse's a$$. :D


In a SELECT-statement column-names or alias-names have to be valid XML-names

wrong attribute-value:
Replace the characters: & < > ' "
with the predefined entities:
&amp; &lt; &gt; &apos; &quote;

from http://bugs.mysql.com/bug.php?id=7811 linked from above link. We had this discussion in another thread.