essjay_d12 Posted February 1, 2007 Share Posted February 1, 2007 I am using MySQL 4.1, however i am about to install sugarCRM and they say mySQL must be at least 4.1.2 - so I need to upgrade - however, I was wondering if i just did a new installation of the latest MySQL will it effect any existing databases that are currently being used in our 4.1?? thanks d Quote Link to comment Share on other sites More sharing options...
shoz Posted February 1, 2007 Share Posted February 1, 2007 I am using MySQL 4.1, however i am about to install sugarCRM and they say mySQL must be at least 4.1.2 - so I need to upgrade - however, I was wondering if i just did a new installation of the latest MySQL will it effect any existing databases that are currently being used in our 4.1?? Are you saying that you're using 4.1.0? Do the following query to see what version you're using exactly SELECT VERSION(); I don't believe that the installation of a new version of 4.1 will affect your databases but if you're going to 5 you could run into trouble. Either way you I'd recommend you do a dump of the databases and make a backup of the data directory. I don't recall if INNODB tables are stored there as well so you'll need to look into that. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2007 Share Posted February 1, 2007 The refman has an extensive list of anything that changes between minor version ticks... I doubt there were any incompatible changes, but you'd have to look. Quote Link to comment Share on other sites More sharing options...
essjay_d12 Posted February 1, 2007 Author Share Posted February 1, 2007 running version 4.1.1 and would like 4.1.2 (less changes the better) where can i get 4.1.2 from? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2007 Share Posted February 1, 2007 Good question... I don't know if the mysql site keep incremental production versions lying around. Quote Link to comment Share on other sites More sharing options...
essjay_d12 Posted February 2, 2007 Author Share Posted February 2, 2007 it doesnt seem like they do, do you have any idea where else i may be able to get it from? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 2, 2007 Share Posted February 2, 2007 I'll see what I can find. Quote Link to comment Share on other sites More sharing options...
shoz Posted February 2, 2007 Share Posted February 2, 2007 Keep in mind that if you don't use the latest version of 4.1 that you'll be missing to any bug/security security fixes that are in the latest version. http://downloads.mysql.com/archives.php?p=mysql-4.1 Still dump the contents of each database and backup your data directory. Even when not upgrading you should have backups. EDIT: Thought I should reword the comment. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 2, 2007 Share Posted February 2, 2007 Not sure why you wouldn't use the latest 4.1.x release -- I think I remember .13 had something important. 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.