<div>
Thank you both.<br />
<br />
I do think he was offering a standard disclaimer ... but appreciate the &quot;boots-on-the-ground&quot; comments.
</div>


Thank you both.

I do think he was offering a standard disclaimer ... but appreciate the "boots-on-the-ground" comments.

<div>
<div class="content wysiwyg-content">
I'm getting my server upgraded from MySQL 5.0 to 5.5.<br />
<br />
The guy doing the upgrade said he does not guarantee that my queries are forward-compatible.<br />
<br />
What kinds of query-related compatibility problems are typical in an upgrade from 5.0 to 5.5?<br />
<br />
Nothing in the list at <a href="http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html" rel="ugc">http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html</a>&nbsp;looks like it will be a problem ... I'm not using a cluster, any partitioning, or any of the &quot;removed features&quot;.<br />
<br />
Nothing in the list at <a href="http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html" rel="ugc">http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html</a>&nbsp;jumps out at me either.<br />
<br />
But ... from real-world experience ... are there some typical problems?<br />
<br />
Thanks!
</div>
</div>


I'm getting my server upgraded from MySQL 5.0 to 5.5.

The guy doing the upgrade said he does not guarantee that my queries are forward-compatible.

What kinds of query-related compatibility problems are typical in an upgrade from 5.0 to 5.5?

Nothing in the list at http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html looks like it will be a problem ... I'm not using a cluster, any partitioning, or any of the "removed features".

Nothing in the list at http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html jumps out at me either.

But ... from real-world experience ... are there some typical problems?

Thanks!

MySql upgrading to 5.5 -- what about queries being compatible?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.