Hi,
Christian Binder wrote:
> Hi,
>
> we have to update our current Database-Server (4.0.20) to Version 5.0.x. on an
> another server.
>
> Our Plan is to migrate the database first and then the php-Applikations, which need
> some tests.
>
> In our migration szenario, we compiled the php-Version of the Webserver with the the
> mysql 5.0.51 -Client on the same server. The phpinfo() shows as client api the version
> 5.0.51. The connects are possible and we have no errors yet.
>
> Is the use of the mysql 5.0.51 client (and the php-mysql API) "supported" for
> connections to the mysql 4.0.20 - Server. I havent found a support-matrix for this
> question.
Yes, it's possible. Be sure when upgrading the MySQL installation you
perform full dump and then import the data in 5.0.51. There are binary
incompatibilities between 4.0/4.1 and 5.0 file formats. Also be careful
with the server charset, if you use more than one charset.
> Thank you for your answers.
>
> Greets
> Christian
Gruesse,
Andrey
--
Andrey Hristov, Connectors Software Developer
MySQL GmbH, Radlkoferstr. 2, D-81373 München, www.mysql.com
Geschäftsführer: Kaj Arnö - HRB München 162140