Vikas Jayna Posted December 26, 2006 Share Posted December 26, 2006 Hi Guys!Has anyone come across a method of upgrading the databse from Mysql 4.0 to Mysql 5.0. Since my database has over a billion records it takes ages to dump the data and to populate the same in the newer version. Is there no tool devised that could directly convert the database files from one format to the other. Have been researching this for some while but no success! Quote Link to comment Share on other sites More sharing options...
Linvo Posted December 26, 2006 Share Posted December 26, 2006 Vikas,I'm sure I can't help you, but I'm in the middle of an upgrade from 4.0.21 to 5.0.27What I did is just copy my databases from the old data directory to the new data directory. :oAfter that, I run the mysql upgrade routine within a dos box and everything is working. :-\BUT, it's awfully slow :( comparing to 4.0.21. I don't know why and if it has something to do with the way I "upgraded"my databases. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 27, 2006 Share Posted December 27, 2006 You only need to dump for certain types of incompatible changes, decmial columns types, etc... so you may be able to cheat a bit. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.