MySQL Forums
Forum List  »  Microsoft SQL Server

feature suggestion (and request for information)
Posted by: Bill Angus
Date: October 29, 2005 09:47PM

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 :)

Options: ReplyQuote

Written By
feature suggestion (and request for information)
October 29, 2005 09:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.