On May 20, 2009, at 1:27 AM, Webmaster Studio Informatica wrote:
> I need to upgrade Mysql 4 to Mysql 5 on Linux.
> I will uninstall version 4 and install version 5.
> With uninstallation usually database files remain in /var/lib/mysql/
> I want to know if with the installation of Mysql 5 those database
> will be "recognized and imported" to work with the new version
In most cases, but you should have a database dump of all of them just
in case. You do not specify what version of 4 you are at.
You need to at least read this:
Specifically look at "Incompatible change", there are quote a few.
Most will not bother you. For me, the biggest issue was my use of
timestamp, and how that changed a bit. Luckily I had a function that
I used in my code to format that timestamp value, so it was just a
matter of going through all my code and updating one function to all
This was also only a display issue for me and did not change my data.
You do have to know your code. If you do not, I would use a staging
server, and do them one database at a time, test, make sure it works,
and go from there.
Scott * If you contact me off list replace talklists@ with scott@ *