Re: Database access in version 3

On 08-04-15 11:15, Ralph Ballier wrote:
> I still use the version 2.2.18 because I have seen on the previous 
> computer only MySQL 4 and not MySQL 5. A switch to the new version of 
> MySQL is too risky to me.
I know I'm not answering you question, but this needs to be said:

You have your priorities screwed. Upgrade MySQL first!

MySQL 4.1.25 stopped getting updates in 2009! Here is a list of Security 
issues for MySQL:
http://www.cvedetails.com/vulnerability-list/vendor_id-185/product_id-316/Mysql-Mysql.html

There is no risk in running MySQL 5.5. It's much faster. Much more 
stable and a better support ecosystem with live backups and such.

The innodb file format hasn't changed much and the upgrade should be 
very smooth. I've upgraded all of my MySQL servers through the years and 
never experienced big issues, except for configuration file changes that 
stopped MySQL from starting. Build a staging server, create your 
configuration file, then upgrade your MySQL 4 server using that config file.