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 Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/ 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. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-174575 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. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-174598 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? Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-174632 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. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-174700 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? Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-175274 Share on other sites More sharing options...
fenway Posted February 2, 2007 Share Posted February 2, 2007 I'll see what I can find. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-175321 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. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-175326 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. Link to comment https://forums.phpfreaks.com/topic/36618-upgrading-mysql-issues/#findComment-175446 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.