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! Link to comment https://forums.phpfreaks.com/topic/31889-upgrade-from-mysql-40-to-50-without-dumping-data/ 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. Link to comment https://forums.phpfreaks.com/topic/31889-upgrade-from-mysql-40-to-50-without-dumping-data/#findComment-147989 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. Link to comment https://forums.phpfreaks.com/topic/31889-upgrade-from-mysql-40-to-50-without-dumping-data/#findComment-148366 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.