MySQL Upgrading
Hi, I am looking at upgrading my servers Debian version from Etch to Lenny, and in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny version, which is 5.0.53 (I think). I have also been thinking about using the 'dotdeb' packages, which will upgrade it even further to 5.1.47. I have done this on a test server, and it all my stored procedures and stuff work fine, so now to my question. Will this break any replication if I don't upgrade my replication server that is still running 5.0.32 (until I upgrade that server as well, which could be a few weeks due to timing)? The other issue, is that the replication server is running multiple instances of the same MySQL on different ports, so that I can replicate multiple sources to a single server (that has attached tape drives for backup purposes), is it possible to run both versions of mysql (the 5.0.32 and the 5.1.47)?granted, this is not the debian mailing list, just thought I would ask that last part ;) Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Upgrading
On Wed, Jun 23, 2010 at 6:33 AM, Steven Staples sstap...@mnsi.net wrote: Hi, I am looking at upgrading my servers Debian version from Etch to Lenny, and in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny version, which is 5.0.53 (I think). I have also been thinking about using the 'dotdeb' packages, which will upgrade it even further to 5.1.47. I have done this on a test server, and it all my stored procedures and stuff work fine, so now to my question. Will this break any replication if I don't upgrade my replication server that is still running 5.0.32 (until I upgrade that server as well, which could be a few weeks due to timing)? It will. I suggest upgrading to at least 5.0.67 if you have no fear of internal users, and the most recent version of 5.0 and 5.1 (I don't recall what they are) if you have fears of malicious users. The other issue, is that the replication server is running multiple instances of the same MySQL on different ports, so that I can replicate multiple sources to a single server (that has attached tape drives for backup purposes), is it possible to run both versions of mysql (the 5.0.32 and the 5.1.47)? granted, this is not the debian mailing list, just thought I would ask that last part ;) Steven Staples -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=wult...@gmail.com -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL upgrading
Was not the command mysqldump -u user -p your_database dump.sql easier to do ? Robert L Cochran wrote: I myself want to go from version 4.1.7 to 4.1.9, so I read the upgrade page, which advises you to back up your databases. You do that with mysqldump, and that is briefly explained here: http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html I added this user comment to the page: --- Before going further, I'm not a deep unix expert, so take my comments with caution. For mysqldump to work, DUMPDIR must be writable by the mysql user. A 'select into outfile' query is executed to get the result set for the *.txt file containing dumped table data, and that file has to be written by the mysql user. For example, on unix systems if you specify /home/well/mysqlbkup as DUMPDIR, then /home/well must be readable by the mysql user and /home/well/mysqlbkup must be writable by the mysql user. When mysqldump creates the *.txt file containing the actual table data, that file is world readable on a unix system. -- It took a long time for me to figure out how to make /home/well/mysqlbkup writable by the mysql user, and I probably did it wrong. If user well is the owner of /home/well, then I changed the permissions from: drwx-- 48 well well /home/well to drwxr-x--- 48 well mysql /home/well and then /home/well/mysqlbkup to: drwxrwxr-x 2 mysql mysql 4096 mysqlbkup On the administrative side I added the 'mysql' user group to the 'well' user group and the 'well' user group to the 'mysql' user group. I probably made mistakes here, but I did succeed in getting my databases backed up. One last note: mysqldump apparently looks at your .my.cnf and executes with the username specified in that file. If that user does not have both select_priv and file_priv access to the database, you won't be able to create a backup of it. I ended up using mysqldump as the root user. Bob Cochran Greenbelt, Maryland, USA Coz Web wrote: Helena, have you tried this link: http://dev.mysql.com/doc/mysql/en/upgrade.html It starts: 2.10. Upgrading MySQL As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0. The following items form a checklist of things you should do whenever you perform an upgrade: ... 2.10.2. Upgrading from Version 4.0 to 4.1 2.10.3. Upgrading from Version 3.23 to 4.0 HTH Coz On Fri, 4 Feb 2005 21:09:21 +0100 (CET), Helena Carlsson [EMAIL PROTECTED] wrote: Hi all, I know this is a silly question but, frankly, I didn't find any useful and straightforward document in dev.mysql.com. I want to upgrade mysql server on a fedora core 3 linux system from 3.23 to the latest version 4.1. First I want to know if is possible, because I have read somewhere that upgrading from 3.23 should be done first to 4.0 and then from 4.0 to 4.1, but I don't know it is right or not ! If it is possible, is there any link to guide ? Thanks, Helena -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL upgrading
Helena, have you tried this link: http://dev.mysql.com/doc/mysql/en/upgrade.html It starts: 2.10. Upgrading MySQL As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0. The following items form a checklist of things you should do whenever you perform an upgrade: ... 2.10.2. Upgrading from Version 4.0 to 4.1 2.10.3. Upgrading from Version 3.23 to 4.0 HTH Coz On Fri, 4 Feb 2005 21:09:21 +0100 (CET), Helena Carlsson [EMAIL PROTECTED] wrote: Hi all, I know this is a silly question but, frankly, I didn't find any useful and straightforward document in dev.mysql.com. I want to upgrade mysql server on a fedora core 3 linux system from 3.23 to the latest version 4.1. First I want to know if is possible, because I have read somewhere that upgrading from 3.23 should be done first to 4.0 and then from 4.0 to 4.1, but I don't know it is right or not ! If it is possible, is there any link to guide ? Thanks, Helena -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- CozWeb Solutions Ltd http://www.cozweb.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL upgrading
I myself want to go from version 4.1.7 to 4.1.9, so I read the upgrade page, which advises you to back up your databases. You do that with mysqldump, and that is briefly explained here: http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html I added this user comment to the page: --- Before going further, I'm not a deep unix expert, so take my comments with caution. For mysqldump to work, DUMPDIR must be writable by the mysql user. A 'select into outfile' query is executed to get the result set for the *.txt file containing dumped table data, and that file has to be written by the mysql user. For example, on unix systems if you specify /home/well/mysqlbkup as DUMPDIR, then /home/well must be readable by the mysql user and /home/well/mysqlbkup must be writable by the mysql user. When mysqldump creates the *.txt file containing the actual table data, that file is world readable on a unix system. -- It took a long time for me to figure out how to make /home/well/mysqlbkup writable by the mysql user, and I probably did it wrong. If user well is the owner of /home/well, then I changed the permissions from: drwx-- 48 well well /home/well to drwxr-x--- 48 well mysql /home/well and then /home/well/mysqlbkup to: drwxrwxr-x 2 mysql mysql 4096 mysqlbkup On the administrative side I added the 'mysql' user group to the 'well' user group and the 'well' user group to the 'mysql' user group. I probably made mistakes here, but I did succeed in getting my databases backed up. One last note: mysqldump apparently looks at your .my.cnf and executes with the username specified in that file. If that user does not have both select_priv and file_priv access to the database, you won't be able to create a backup of it. I ended up using mysqldump as the root user. Bob Cochran Greenbelt, Maryland, USA Coz Web wrote: Helena, have you tried this link: http://dev.mysql.com/doc/mysql/en/upgrade.html It starts: 2.10. Upgrading MySQL As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0. The following items form a checklist of things you should do whenever you perform an upgrade: ... 2.10.2. Upgrading from Version 4.0 to 4.1 2.10.3. Upgrading from Version 3.23 to 4.0 HTH Coz On Fri, 4 Feb 2005 21:09:21 +0100 (CET), Helena Carlsson [EMAIL PROTECTED] wrote: Hi all, I know this is a silly question but, frankly, I didn't find any useful and straightforward document in dev.mysql.com. I want to upgrade mysql server on a fedora core 3 linux system from 3.23 to the latest version 4.1. First I want to know if is possible, because I have read somewhere that upgrading from 3.23 should be done first to 4.0 and then from 4.0 to 4.1, but I don't know it is right or not ! If it is possible, is there any link to guide ? Thanks, Helena -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL upgrading
Hi all, I know this is a silly question but, frankly, I didn't find any useful and straightforward document in dev.mysql.com. I want to upgrade mysql server on a fedora core 3 linux system from 3.23 to the latest version 4.1. First I want to know if is possible, because I have read somewhere that upgrading from 3.23 should be done first to 4.0 and then from 4.0 to 4.1, but I don't know it is right or not ! If it is possible, is there any link to guide ? Thanks, Helena -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: RE: Mysql - Upgrading from 3.23.53 to 3.23.54
On Tuesday 17 December 2002 19:27, Santiago Alba wrote: I installed binary version (source distribution)... not with rpm So, binary or source distribution? Please, be clear. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql - Upgrading from 3.23.53 to 3.23.54
Please, anybody could help me with this? Anybody have upgraded its MySQL release from 3.23.53 to Mysql release 3.23.54... I need to upgrade for fixing a bug in 3.23.53 and I would like to know if it necesary to reinstall as the one solution. Thanks a lot. - Original Message - From: Santiago Alba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 16, 2002 3:24 PM Subject: Mysql - Upgrading from 3.23.53 to 3.23.54 Hi, I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? Any suggest? Thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Mysql - Upgrading from 3.23.53 to 3.23.54
On Monday 16 December 2002 16:24, Santiago Alba wrote: I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? As usual ;) Seriously speaking - depends on the way have you installed it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql - Upgrading from 3.23.53 to 3.23.54
Hi. You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of hours to discover, why source rpm 3.23.54a don't rebuild ) autoconf is 2.52 libtool is 1.4.3 Regards. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 2:02 PM Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54 On Monday 16 December 2002 16:24, Santiago Alba wrote: I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? As usual ;) Seriously speaking - depends on the way have you installed it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --r-e-k-l-a-m-a- Masz dosc placenia prowizji bankowi ? mBank - zaloz konto http://epieniadze.onet.pl/mbank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql - Upgrading from 3.23.53 to 3.23.54
I installed binary version (source distribution)... not with rpm - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 2:02 PM Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54 On Monday 16 December 2002 16:24, Santiago Alba wrote: I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? As usual ;) Seriously speaking - depends on the way have you installed it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql - Upgrading from 3.23.53 to 3.23.54
Sorry, but I don´t understand you... I have no idea, if you don't mind you could be more expecific... Thanks a lot for your answer. - Original Message - From: Ireneusz Piasecki [EMAIL PROTECTED] To: Egor Egorov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 2:20 PM Subject: Re: Mysql - Upgrading from 3.23.53 to 3.23.54 Hi. You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of hours to discover, why source rpm 3.23.54a don't rebuild ) autoconf is 2.52 libtool is 1.4.3 Regards. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 2:02 PM Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54 On Monday 16 December 2002 16:24, Santiago Alba wrote: I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? As usual ;) Seriously speaking - depends on the way have you installed it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --r-e-k-l-a-m-a- Masz dosc placenia prowizji bankowi ? mBank - zaloz konto http://epieniadze.onet.pl/mbank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql - Upgrading from 3.23.53 to 3.23.54
Hi, I have installed MySQL 2.23.53 release and I want to upgrade to MySQL 2.23.54... how can I do this? Have i got to reinstall? Is there any script? Any suggest? Thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php