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
On 1/13/10 2:28 PM, Lawrence Sorrillo sorri...@jlab.org 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
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 both
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 sorri...@jlab.org wrote:
Hi:
I want to upgrade a master and slave server from mysql 4.1 to 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 sorri...@jlab.org wrote:
Hi:
I want to upgrade a master and slave server from 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,
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
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
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 these
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 sorri...@jlab.org wrote:
This is two upgrades done in sequence(the reload takes about three hours
per
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
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
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.
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) the
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:
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-server (4.1.10a-1.i386) and are
running
into some serious problems. we
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 same
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.
actually,
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 to do
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) running,
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:
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
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!
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
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 MacOS X
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 link
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
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 know
This is covered in the manual
http://dev.mysql.com/doc/mysql/en/Password_hashing.html: 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 able
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
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
: 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
, 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:
NOKEY, key ID 5072e1f5
Preparing
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, i think you must
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, August 2, 2004 6:19
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 assistance
It
-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
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
[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
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
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] wrote
]
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 upgrading the real server during off-peak
-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 platform
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
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:
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 symlink
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
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 rpm
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:
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 mysql
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
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
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
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: Upgrading MySQL causes Error - ASP
54 matches
Mail list logo