feature suggestion (and request for information)

[Bill Angus]

Suppose someone wants to upgrade from MySQL 4.1 to 5.0. Why is there no feature provided (either in the query browser or in a script file) which will allow an admin. to sign onto a new install of 5.0 and import the data from the old 4.1 /data directory (inluding user tables, and all other 4.1 format data tables) into the new 5.0 data directory (in the correct 5.0 format).

Most production software houses would not omit to provide an easy upgrade/transition path for current users of the previous versioned product. MySql should perhaps consider doing the same. It seems this would be a very easy thing to provide, and an unnecessary pain for everybody else to do on their own.

Failing the existence of the above ... can anyone give a complete step by step as to how to get all the databases (including the old MySQL users,priviledges,etc.) into a new 5.0 install from a previous 4.1 install.

I found quite a bit of info in different places in the 5.0 manual -- but I want to be sure that I do a proper transition.... Then when things start to fail -- I will not have to suspect it may be faulty data transfer problem, and can work out what else might be wrong :)