On 03/09/2010 12:23 p, Machiel Richards wrote:
Good day allI am looking for someone that can maybe help me with some info regarding the upgrading of MySQL. We have a MySQL database currently running with a master/slave replication setup. The current version of the database is as follows: mysql> select version(); +------------------------------+ | version() | +------------------------------+ | 5.0.72sp1-enterprise-gpl-log | +------------------------------+ 1 row in set (0.00 sec) This is currently running on RedHat. This database is however set to be migrated to new hardware later during this month and discussions have been in place in order to upgrade the Database to the latest version possible. As it would seem, the latest enterprise (pro/advanced) version available are version 5.1.46sp1 and version 5.1.50 which includes the interim updates as well. I am trying to find someone who has had experience and can give me some pointers in the following regard as this will be my first database upgrade: 1. which one of these two version will be the best to upgrade to. 2. where can I get information on how to upgrade the database itself 3. has anyone done this before? if so, is there anything that we should look out for? I would really appreciate the help here. Regards Machiel
In the old machine mysqldump -p etc etc dbname > database.sql then copy the database.sql to the new machine and run mysql -p < database.sql It should work regardless of the version you are exporting/importing to. -- Jangita | +256 76 91 8383 | Y! & MSN: [email protected] Skype: jangita | GTalk: [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
