Re: upgrading mysql

On Jan 13, 2010, at 1:28 PM, Lawrence Sorrillo wrote: > The issue is that in theory this should work given the facts announced by > MySQL regarding binary logging and replication. > I can certainly do it the way you propose, but to my mind I should also be > able to do it using the fact that bo

Re: upgrading mysql

On 1/13/10 2:28 PM, "Lawrence Sorrillo" wrote: > The issue is that in theory this should work given the facts announced > by MySQL regarding binary logging and replication. > I can certainly do it the way you propose, but to my mind I should also > be able to do it using the fact that both machin

Re: upgrading mysql

The issue is that in theory this should work given the facts announced by MySQL regarding binary logging and replication. I can certainly do it the way you propose, but to my mind I should also be able to do it using the fact that both machines are fully synced and hence at that point I should b

Re: upgrading mysql

Hi, The step 6 in simple terms is Here we need to build two server ( both master and slave ). Instead of building two server as it takes double the time of building in one server. After building an server, make a copy of the first server files at OS level and copy it to the server and start the sa

Re: upgrading mysql

Frankly, I didn't entirely understand what you were proposing. I got lost around step 6. Is the issue total time for the procedure or service downtime? On 1/12/10 12:58 PM, "Lawrence Sorrillo" wrote: > This is two upgrades done in sequence(the reload takes about three hours > per machine) . I

Re: upgrading mysql

On Jan 12, 2010, at 12:36 PM, Lawrence Sorrillo wrote: > Hi: > > I want to ensure that right after the reload that the same data is present in > both the master and the slave. They are in perfect sync. Then I think its > safe to consider starting binary logging and replication etc. And after t

Re: upgrading mysql

Hi: I want to ensure that right after the reload that the same data is present in both the master and the slave. They are in perfect sync. Then I think its safe to consider starting binary logging and replication etc. And after these are started, changes can start? And in setting up replicat

Re: upgrading mysql

Lawrence Sorrillo wrote: Hi: I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1. I want to so something like follows: 1. Stop all write access to the master server. ok 2. Ensure that replication on the slave is caught up to the last change on the master. why? You are

Re: upgrading mysql

This is two upgrades done in sequence(the reload takes about three hours per machine) . I can do what I am proposing in parallel. Do you see it as problematic? ~Lawrence Tom Worster wrote: How about: 1 shut down the slave, upgrade it, restart it, let it catch up. 2 shut down the master, up

RE: upgrading mysql

: upgrading mysql How about: 1 shut down the slave, upgrade it, restart it, let it catch up. 2 shut down the master, upgrade it, restart it, let the slave catch up. ? On 1/12/10 12:34 PM, "Lawrence Sorrillo" wrote: > Hi: > > I want to upgrade a master and slave serve

Re: upgrading mysql

How about: 1 shut down the slave, upgrade it, restart it, let it catch up. 2 shut down the master, upgrade it, restart it, let the slave catch up. ? On 1/12/10 12:34 PM, "Lawrence Sorrillo" wrote: > Hi: > > I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1. > > I w

Re: Upgrading MySQL from 5.0 to 5.1

What I always did since 3.23 upwards is new installation and import. My tecnique allows me to install as many mysql instances as I want, I always use specific user, homedir, datadir, my.cnf, for each installation. In this way I can have theoretically unlimited number of mysql instances on one host.

Re: upgrading mysql on RHEL4

Hi ! perl pra schrieb: > [[...]] > > Also please tell me where can i get mysql5.1 enterprise edition. 5.1 is currently labeled "rc" (current version is 5.1.22-rc), so there is no enterprise edition yet. When there will be one, it will be for paying customers, and they have got (or will receive)

Re: upgrading mysql on RHEL4

Hi, Take backup of the existing data before upgrading for safety. There is RHEL 4 specific rpm binary is existing in the downloading section. After installing run the required tools comes with mysql. Before upgrading with existing datas read the documentation carefully. http://dev.mysql.com

Re: upgrading mysql...

On 8/2/06, bruce <[EMAIL PROTECTED]> wrote: hi.. i have FC3, with 4.1.13, i also have FC4 with 4.1.20. however, i can't seem to find 5.0.x RPMs for FC3/4. do i have to go ahead and build this from source for the FC3/4 boxes that i have... Linux x86 generic RPM at: http://dev.mysql.com/downloa

RE: upgrading mysql on RH fedora core 3

- From: Florin Andrei [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 8:40 PM To: mysql@lists.mysql.com Subject: Re: upgrading mysql on RH fedora core 3 On Tue, 29 Mar 2005 19:28:56 -0800, bruce <[EMAIL PROTECTED]> wrote: > > we're trying to install mysql/mysql-se

Re: upgrading mysql on RH fedora core 3

On Tue, 29 Mar 2005 20:39:54 -0800, Florin Andrei <[EMAIL PROTECTED]> wrote: > On Tue, 29 Mar 2005 19:28:56 -0800, bruce <[EMAIL PROTECTED]> wrote: > > > > we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running > > into some serious problems. we had mysql/server (3.23.52-3.i386

RE: upgrading mysql on RH fedora core 3

On Tuesday, March 29, 2005 21:29, bruce wrote: > hi... > > we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are > running into some serious problems. we had mysql/server > (3.23.52-3.i386) running, but needed to go to the higher version... > > can someone tell us how/what we need

Re: upgrading mysql on RH fedora core 3

bruce wrote: >hi... > >we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running >into some serious problems. we had mysql/server (3.23.52-3.i386) running, >but needed to go to the higher version... > >can someone tell us how/what we need to do to get this working correctly. >act

Re: upgrading mysql on RH fedora core 3

On Tue, 29 Mar 2005 19:28:56 -0800, bruce <[EMAIL PROTECTED]> wrote: > > we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running > into some serious problems. we had mysql/server (3.23.52-3.i386) running, > but needed to go to the higher version... I was about to attempt the s

Re: Upgrading mySql from 3.23 to 4.1.10

Hello. Install MySQL-client-4.1.10-0.i386.rpm. "Troy Richard" <[EMAIL PROTECTED]> wrote: > I have upgraded from mysql 3.23 to 4.1.10 everything seems to be working. > I'm trying to run the mysql_fix_privilege_tables script to update the > privileges and I'm getting the following error:

Re: Upgrading MySql on OSX 10.3.6

The directory mysql is a symbolic link to one of the other dirs. If mysql points to old one rename it and make a new one: mv mysql mysqlold ls -s mysql-max-4.1.7-apple-darwin7.5.0-powerpc mysql Do not remove mysql-max-4.0.20-apple-darwin7.3.0-powerpc/data it contains your old databases!!! Santino

RE: Upgrading MySQL erased all data

Thanks. I passed this on and he found what was lost. I guess since the data directory was owned by mysql, he could not find the databases when doing a MacOS file search. I impressed upon him to use a separate datadir as we do with our servers, thus bypassing this whole thing. Thanks again! -steve

Re: Upgrading MySQL erased all data

Are you sure? /usr/local/mysql is a symbolic link to another direcory ( /usr/local/mysql(version). I think the installer overwrite the symbolic link so if you open a terminal and type: ls -l /usr/local Santino At 16:20 -0700 28-10-2004, Steven Roussey wrote: Installing MySQL 4.1.7 (upgrading f

Re: Upgrading MySQL erased all data

So, do you have a question or are you just bragging? ;-) Rhino - Original Message - From: "Steven Roussey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 7:20 PM Subject: Upgrading MySQL erased all data > Installing MySQL 4.1.7 (upgrading from 4.1.3) on Ma

RE: Upgrading MySQL. Caveats or Cautions anyone?

Hi, I found that the Intel C++ version needed some libraries which weren't on my RH9.0 system (this was when upgrading to 4.1.4g): libcprts.so.5 libcxa.so.5 libunwind.so.5 This seems to have been reported many times e.g. http://bugs.mysql.com/bug.php?id=4408 The resolve was to get the lib

Re: Upgrading MySQL. Caveats or Cautions anyone?

Tim Johnson <[EMAIL PROTECTED]> wrote: The simpliest way: Download and install MySQL Official Binary RPMs from www.mysql.com. They will install on your server and run fine. You'd also want to install the shared-compat RPM in case you have something compiled with older libmysqlclient. The lin

Re: Upgrading MySQL. Caveats or Cautions anyone?

You can ignore both of those if you use the binaries. -Eric On Fri, 17 Sep 2004 18:43:02 -0800, Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello: > Am currently using Ver 11.18 Distrib 3.23.58 > on Linux 2.4.20-20.9. (RH 9.0). > > I'd like to upgrade to the current version. I would > like to

Re: Upgrading Mysql and Perl DBD

This is covered in the manual : "A 4.1 client can connect to a pre-4.1 server, because the client understands both the old and new password hashing mechanisms." So, if you build the Perl modules against the 4.1.x library, you should be a

Re: Upgrading mySQL 3.23 to 4.0

Can you give me a bit more detailed instructions on what i am uninstalling and what I should back up? Thanks Wolfgang Riedel wrote: [EMAIL PROTECTED] schrieb: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have "mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-

Re: Upgrading mySQL 3.23 to 4.0

On Mon, 02 Aug 2004 17:31:03 -0400 [EMAIL PROTECTED] wrote: > I am now getting > > [EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > any thoughts... > > once again thanks for the assist

Re: Upgrading mySQL 3.23 to 4.0

[EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Upgrading mySQL 3.23 to 4.0 Date: Mon, 02 Aug 2004 18:26:05 -0400 in my Linux Services... the mysqld entry is missing i have mysql and that is supposedly running. - Original Message - From: Carlos Proal <[EMAIL PROTECTED]> Date: Monday, Augu

Re: Upgrading mySQL 3.23 to 4.0

in my Linux Services... the mysqld entry is missing i have mysql and that is supposedly running. - Original Message - From: Carlos Proal <[EMAIL PROTECTED]> Date: Monday, August 2, 2004 6:19 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 > > The upgrade shutdown the database,

Re: Upgrading mySQL 3.23 to 4.0

D] Date: Monday, August 2, 2004 5:26 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 > I wound up having to do the following: > > [EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-compat-4.0.20- > 0.i386.rpm > warning: MySQL-shared-compat-4.0.20-0.i386.rpm: V3 DSA signature: > N

Re: Upgrading mySQL 3.23 to 4.0

day, August 2, 2004 5:12 pm Subject: Re: Upgrading mySQL 3.23 to 4.0 > At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote: > >Greetings: > > > > I am trying to upgrade to the new version of mySQL on Fedora > Core 2 > > Linux. I have "mysql Ver 11.18 Distrib 3.23.5

Re: Upgrading mySQL 3.23 to 4.0

At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote: Greetings: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have "mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)" I downloaded the following files: MySQL-client-4.0.20-0.i386.rpm MySQL-server-4.0.20-0.i3

Re: Upgrading MySQL on RedHat 9

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 2 Jul 2003, Paul DuBois wrote: > At 11:33 -0400 7/2/03, Andrew Pierce wrote: > >I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to > >go from the version that came with the distro (version 3.23.54) to the > >latest

Re: Upgrading MySQL on RedHat 9

At 11:33 -0400 7/2/03, Andrew Pierce wrote: I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate

RE: upgrading mysql

lleman [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED] wrote: > Can someone help > point me in the right direction? Thanks I just finished a practice upgrade (on a back-up server) myself and will be upgra

RE: upgrading mysql

our VA Linux > box > and have used the binaries for the last two or three upgrades. Our builds > were really unstable and buggy under a high load, but the binaries have > been > great. > > Hope that helps > > -Original Message- > From: Tab Alleman [mailto:

RE: upgrading mysql

upgrades. Our builds were really unstable and buggy under a high load, but the binaries have been great. Hope that helps -Original Message- From: Tab Alleman [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: [EMAIL PROTECTED] Subject: RE: upgrading mysql [EMAIL PROTECTED

RE: upgrading mysql

[EMAIL PROTECTED] wrote: > Can someone help > point me in the right direction? Thanks I just finished a practice upgrade (on a back-up server) myself and will be upgrading the real server during off-peak hours soon. We are running win2k servers so I can't speak directly to any linux issues, but

Re: Upgrading MySQL/Solaris 2.7

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 17 Dec 2002, John P wrote: > I want to upgrade my MySQL version (3.23.51) because of the recently > revealed exploit; the only binary dist on mysql.com for solaris 2.7 is > 3.23.53; will there be a problem compiling from source on this platfor

Re: Upgrading MySQL from 3.23.41 to 3.23.53a

At 13:47 2002-11-13 -0500, Rick Root wrote: [root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm error: failed dependencies: MySQL conflicts with mysql-3.23.41-1 MySQL-server conflicts with mysql-server-3.23.41-1 [root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm error: fa

RE: Upgrading MySQL from 3.23.41 to 3.23.53a

You might need to use rpm -e to uninstall previous version first. Check the documentation. ~Kelly W. Black -Original Message- From: Rick Root [mailto:rroot@;wakeinternet.com] Sent: Wednesday, November 13, 2002 10:47 AM To: mysql Subject: Upgrading MySQL from 3.23.41 to 3.23.53a I woul

Re: Upgrading mysql from 3.22 to 3.23

Hi, On Tue, 2002-03-19 at 11:41, Campbell McLeay wrote: > I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and > had a few basic questions which I am hoping someone can help me with. > My plan is simply to download and unpack the binary distribution, stop > mysqld, move the symli

Re: upgrading mysql-3.23.48 and rpm package.

Ireneusz, Tuesday, February 12, 2002, 11:46:40 AM, you wrote: IP> HI. IP> No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. IP> I could'nt install it. IP> I have rpm 3.0.4. on my RH 6.2 (Zoot) box. IP> Is there on the NET, rpm package of mysql-3.23.48, which can i install with IP> r

Re: upgrading mysql-3.23.48 and rpm package.

hi, on redhat 6.2, you have a package manager (rpm) version which cannot interpret rpm's created with package manager version 4. afaik, rpm 3.0.6 is able to read both formats, so you should upgrade your package manager software to version 3.0.6 to be able to install the new mysql package. don't

Re: upgrading mysql-3.23.48 and rpm package.

HI. No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. I could'nt install it. I have rpm 3.0.4. on my RH 6.2 (Zoot) box. Is there on the NET, rpm package of mysql-3.23.48, which can i install with rpm 3.0.4 ? - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[

Re: Upgrading mysql on Win2K

Date |Tue, 7 Aug 2001 13:07:46 -0700 >From |"A. Clausen" <[EMAIL PROTECTED]> Hello! AC> What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just install over top or is there some other steps that should be taken? No.You can just install new version. AC> I am running two

Re: Upgrading MySQL on Windows Platform

At 14:32 21/06/2001 -0700, Martin Tunggorono wrote: Hi! >Hi everyone, > >I'm kinda new with MySQL and I have a question about upgrading MySQL to a >newer version on Windows 2000 OS. Is there any special command that I >should run or should I just re-install the latest version 3.23.39. Will it >ove

RE: Upgrading MySQL on Windows Platform

Yes, just stop the mysql service before you begin installation by running something like net stop mysql from a command prompt. > Hi everyone, > > I'm kinda new with MySQL and I have a question about upgrading MySQL to a > newer version on Windows 2000 OS. Is there any special command that I > s

Re: Upgrading MySQL causes Error - ASP

at I think it should be something related to GROUP BY clause. Celso. - Original Message - From: Gerald L. Clark <[EMAIL PROTECTED]> To: Celso Pires <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 11:11 Subject: Re:

Re: Upgrading MySQL causes Error - ASP

They replaced your MySQL with a new version. Did they re-compile Apache and PHP to use the new MySQL libraries, or is it trying to use the now missing ones? Celso Pires wrote: > > Hi there, > > I've got a site hosted at an ISP and everything was going well when they > decided to upgrade the sof