On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, william
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
|
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It seems that
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slave
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next
Whilst there are a few possibilities, check on the master that your binary
logs are being written to. Another possible reason could be filtering.
On 29 Aug 2014 21:36, william drescher will...@techservsys.com wrote:
Replication novice
I have a master server at the office and a replication
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master, is the Exec_Master_Log_Pos incrementing or not?
3-) Why are you reconfiguring all the replication just
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com m...@wagnerbianchi.com
wrote:
Hello guys, some points to check here:
1-) Is
On 12/3/2012 7:24 AM, Trimurthy wrote:
hi list, i am trying to set up replication but i couldn't
complete because of the following error
Could not find first log file name in binary log index file can any one
please help me.
... snipped ...
This one should have been easy for the
directory are the binlogs in?
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Monday, December 03, 2012 8:53 AM
To: trimur...@tulassi.com
Cc: mysql@lists.mysql.com
Subject: Re: replication problem
Trimurthy,
you will have to describe the method
Trimurthy,
you will have to describe the method you are using to setup
replication. The error message seems plain but an observer could not
reasonably guess what caused it without more information.
- michael dykman
On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy trimur...@tulassi.com wrote:
hi
SHOW SLAVE STATUS\G
SHOW MASTER STATUS;
What directory are the binlogs in?
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Monday, December 03, 2012 8:53 AM
To: trimur...@tulassi.com
Cc: mysql@lists.mysql.com
Subject: Re: replication problem
Trimurthy
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 tyzha...@gmail.com wrote:
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables
Hi,
Jorge Martínez wrote:
We have a windows server running our main database and an IIS server. We also
have a linux box with apache/php that uses the same database server.
We have configured a replication from that host to another windows server. Then we verified that not all the queries
: Replication problem Hi, Jorge Martínez wrote: We have a windows
server running our main database and an IIS server. We also have a linux box
with apache/php that uses the same database server.We have configured a
replication from that host to another windows server. Then we verified that not
all
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http://lists.mysql.com/mysql/190869
Regards,
Atle
FCI, Inc. - Unix Systems Administrator
On Tue, 12 Dec 2006, Ed Pauley II wrote:
We recently upgraded to MySQL 5.0. Since upgrading I
Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http
t
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:49 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Hello David,
Reset how? I
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:28 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Dave,
I tried reset slave as you mentioned - no change. Nothing
David,
mysql show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| FMSweb-bin.01 | 903763 | |
: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
mysql show master status\g
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB
nt
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 9:51 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
mysql show master
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 11:06 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
I could try and create a table. But I've got it set just
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding-relay-bin on the slave server that I
@lists.mysql.com
Subject: RE: Replication Problem
David,
Thanks for attempting to help.
When I look at my show slave status, its updating. When I look at
the FMSbuilding-relay-bin, its updating! It has the information
that's taken place on the master server. I can see information in
the FMSbuilding
David,
It is pointing correctly. Plus, I can use a mysql browser and 3rd
party tools on the slave server and read the databases/tables
properly.
I've tried stopping and restarting. I've rebooted... I'm baffled
too, obviously. lol
Thanks!
Brett
I am absolutely baffled as to how the
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 July 2006 10:18 AM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
David,
It is pointing correctly. Plus, I can use
David,
that error is only when doing a stop/shutdown. So it doesnt make a
lot of sense that would be the problem.
Here's the log where I did a stop and start.
060724 20:54:25 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: Normal shutdown
060724 20:54:25 [ERROR] Error
Hi,
Did u mention what all databases has to be replicated in ur cnf file as
(replicate-do-db=database-name).
Thanks Regards
Dilipkumar
- Original Message -
From: Brett Harvey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 8:49 AM
Subject: Replication
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks Regards
Dilipkumar
--
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:36 PM
To: mysql@lists.mysql.com
Subject: Re: Replication Problem
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u
Hi,
Check whether u have starting with the correct master position from slave.
Thanks Regards
Dilipkumar
- Original Message -
From: Brett Harvey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, July 24, 2006 9:36 AM
Subject: Re: Replication Problem
Hi,
Thanks
@lists.mysql.com
Subject: Re: Replication Problem
Hi,
Thanks for the response.
Yes - I have that in my config also.
replicate-do-db=FMS
Thanks
Brett
Hi,
Did u mention what all databases has to be replicated in ur cnf file
as (replicate-do-db=database-name).
Thanks Regards
Dilipkumar
---
-Original Message-
From: Brett Harvey [mailto:[EMAIL PROTECTED]
Sent: Monday, 24 July 2006 1:49 PM
To: mysql@lists.mysql.com
Subject: RE: Replication Problem
Hello David,
Reset how? I did the CHANGE MASTER TO and set it as what was
specified from the Show Master command after I
Hello.
However, this does not seem to replicate to the slave, and no error shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs? See:
http://dev.mysql.com/doc/mysql/en/slave-logs.html
- Original Message -
However, this does not seem to replicate to the slave, and no error
shows
Have you compared the slave's relay logs and master's binary logs? Does
this query present in both logs?
The hint was what I needed, Gleb. Spasibo. It turns out that the
If nothing helps, trace files could spill the light on your problem.
many thanks for your help. With tracing I found the problem. Like almost
every time it was just a typing error :-(
Regards Jan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello.
If nothing helps, trace files could spill the light on your problem.
See:
http://dev.mysql.com/doc/mysql/en/making-trace-files.html
Jan Roehrich [EMAIL PROTECTED] wrote:
--skip-networking can be specified as the command line option. Use:
show variables like
Hello.
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Jan Roehrich [EMAIL PROTECTED] wrote:
I have a strange problem setting up replication. I followed each step of
setting up replication in the
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Master:
--
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=bin-log
server-id=1
[mysql.server]
Hello.
Could not see skip-networking anywhere.
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
Jan Roehrich [EMAIL PROTECTED] wrote:
Please send your configuration files for master and
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
Jan Roehrich wrote:
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
|
Hello.
I suggest you to check what query was written to the master binary log
and then report a bug. Please include all information you've found in the
report.
Weicheng Pan [EMAIL PROTECTED] wrote:
Dear Gleb:
The problem has occured again, and I grab some output.
This box run
very much.
With best regards,
Weicheng Pan
Jun 3, 2005.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 02, 2005 4:51 PM
Subject: Re: Replication problem
Hello.
I suggest you to check what query was written to the master
] [ /home/mysql ]
With best regards,
Weicheng.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, May 30, 2005 5:20 PM
Subject: Re: Replication problem
Hello.
Not enough information to make a conclusion. What version of
MySQL do you use
Hello.
Not enough information to make a conclusion. What version of
MySQL do you use? Usually debugging of replication problems
begins from researching of binary logs with mysqlbinlog. See:
http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
Hello.
Error: 'Unknown MySQL server host
'server5.domain.com' (1)' errno: 2005
Does the problem remain if you remove the following line
from the my.cnf on the server8:
skip-networking
Chris Mason [EMAIL PROTECTED] wrote:
I have two servers, server5.mydomain.com and
On 10/06/2004 6:23 PM, Bill Thomason [EMAIL PROTECTED] wrote:
I originally posted a query about a problem entitled Table doesn't
exist on query replication problem...
The original title might be a little misleading. The slave replication
is halting on a transaction that contains a query
On Friday 20 August 2004 07:08, [EMAIL PROTECTED] might have typed:
Is replication of database in MySQL is possible. Actually i want to
replicate the changes to the database to different servers located at
different locations.
A tiny bit of legwork would have answered it for you.
On Tue, Aug 03, 2004 at 12:44:05PM +0530, [EMAIL PROTECTED] wrote:
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got
somebody here can make sense of it. On the slave I get error messages
like:
040630 2:43:52 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.163' at
position 37919441
It does that several times between 2:20am and 4:30am. and every few
Ah..
Hi,
On Wed, Apr 21, 2004 at 06:35:53PM +0200, Mechain Marc wrote:
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Ahh, that's what i was looking for. Seems as if i had not read chapter 6
of the documentation thoroughly enough...
Thanks,
Georg
--
MySQL General Mailing List
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Marc.
-Message d'origine-
De : Georg Horn [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 avril 2004 17:31
À : [EMAIL PROTECTED]
Objet : Replication problem
Hi,
i'm new to this list, but i use mysql for years an are very
I have your same problem in my network where the master i 3.23.52 and then
slave are 4.0.14; before, in all 4.0.13, it was ok, without this bug.
It will be solved in 4.0.15 ?
Best regards
Massimo
- Original Message -
From: I.P. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
You can use an option in my.cnf slave-skip-error=list error nums
separated by ,.
The error below means that the master had a shutdown event and the slave
can't tell if it added / deleted / changed that row or not. I wouldn't
advise in skipping this error less you want your data to be
On Wed, Aug 06, 2003 at 12:16:40PM -0400, walt wrote:
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
$ cat mysql/master.info
angora-bin.001
20102800
127.0.0.1
repl
removed
3306
60
Looks fine to me. :(
Looks fine to me as well
Are you still getting the 1200
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
I don't
On Wed, Aug 06, 2003 at 11:23:31AM -0400, walt wrote:
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master setup. I see log-bin, but I think that only applies to
updates done directly to the database (not replication updates).
System [EMAIL PROTECTED] wrote:
Hello All,
I have setup Replication on two Redhat linux box 7.3 and 9.0 with
MySQL-4.0.13 Running..
On Master the my.cnf is
==
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
port
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
There is one more thing I can think of to check...
Can you send me a copy of the
master.info file. I've had to manually change it before after changing
the master in the my.cnf file. I found out later that you could do
CHANGE MASTER
On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote:
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening on that
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
On Wed, Aug 06, 2003 at 02:19:21PM +0100, Andy Smith wrote:
Hi folks, trying to set up replication and I'm getting this problem
which I can't see how to fix despite reading of the manual and
google.
I
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
Otherwise, it sounds like the config information is not properly set --
either
On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master setup. I see log-bin, but I think that only applies to
On Wed, Aug 06, 2003 at 10:32:23AM -0400, walt wrote:
Andy,
Can you send a copy of your my.cnf file for both the slave and master
database.
Sure.
Slave:
[client]
port=3307
socket=/data/mysql-backup/mysql.sock
[mysqld]
port=3307
socket=/data/mysql-backup/mysql.sock
server-id=4
log-warnings
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening on that
port?
$ netstat -an | grep 3306
tcp0 0
the opens source comunity ...
- Original Message -
From: Jonathan Fowler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 4:34 AM
Subject: Re: replication problem
www.kapadiaz.com = download free movies songs and also free 5 gb hosting
--
MySQL General Mailing List
www.kapadiaz.com = download free movies songs and also free 5 gb hosting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Naoufal Rih [EMAIL PROTECTED] wrote:
Hi
I have 3 machines M1 M2 and M3, i need to setup the following :
M1 is the master
M2 is reading from M1
M2 is a master for M3
M3 is reading from M2
The problem i got, is when i run a command in M2, it's replicated in M3,
but when the command is being
Andrew Staples wrote:
I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state. The newest production version is 3.23.55,
am I right? Do you recommend this version for testing?
Regards,
Kirill
Egor Egorov wrote:
On Tuesday
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote:
Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state.
Yup, 4.0.X is gamma.
The newest production version is 3.23.55,
am I
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
Coud you, please, give an advice to solve following problem:
I've got two Mysql Servers:
* Master: Sparc Solaris 8, MySQL 3.23.32
* Slave: RedHat Linux 7.2, MySQL 3.23.32
Replication of data runs fine, all insert
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: re: Replication problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
Coud you, please, give an advice to solve following
To: [EMAIL PROTECTED]
Subject: re: Replication problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
Coud you, please, give an advice to solve following problem:
I've got two Mysql Servers:
* Master: Sparc Solaris 8, MySQL 3.23.32
* Slave
I've narrowed it down a lot. We have two different PHP interfaces for the
database. One is for employees to access the data, and the other is for
customers. The UPDATEs and INSERTs on the system that customers use is not
being replicated, but the one that employees is working perfectly.
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
I set up replication on my servers since the version 3.23.43. Recently I
upgrade all my servers to version 4.0.3.
The replication work fine for insert and delete queries (also alter table)
but doesn't take care of update queries.
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP We are having a problem which seems to have appeared recently with
DP replication on our mysql servers.
DP - We have 3 servers set up with mysql 3.23.52 (they were running .49 but
DP we upgraded in an attempt to fix this problem,
Piasecki
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 8:34 AM
To: [EMAIL PROTECTED]
Subject: re: replication problem
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP We are having a problem which seems to have appeared
/mysqld/mysqld.pid
---
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 08, 2002 3:45 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't log into master
On Thu, Sep 05, 2002 at 09:52
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote:
I am attempting to setup MySQL replication between the ctiadb1 (master)
server and the ctiadb2 (slave) server.
When I look at the mysql.log file on the slave, I see the following
(repeated every 60 seconds):
020904 12:00:30
: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 11:02 PM
To: Jamie Beu
Cc: [EMAIL PROTECTED]
Subject: Re: Replication problem: slave can't log into master (update)
Pada Thu, 5 Sep 2002 12:35:45 -0400
Jamie Beu [EMAIL PROTECTED] menulis :
I am still having
Pada Thu, 5 Sep 2002 12:35:45 -0400
Jamie Beu [EMAIL PROTECTED] menulis :
I am still having problems with the slave server being able to connect to
the master, but a thought occured to me while we were working another topic.
Please let me know what I'm missing. I can do the following:
At 05:27 PM 8/20/2002 -0400, walt wrote:
I have added this one, thanks.
Hmmm...
When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI
to the slave database?
Ok, after a lot of hair-pulling, I downgraded and used 3.23, and what do
you know, replication worked out fine
Froilan Mendoza wrote:
Hello,
I have two machines that I am trying to use replication on. Here are their
configurations:
master (my.cnf)
log-bin
serveri-d = 1
slave:
server-id = 2
master-host=master.domain.com
master-user=replicate
master-password=replicatedb
log-bin
I
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
on the slave you should run
show slave status
on slave:
mysql show slave status;
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote:
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
on the slave you should run
show slave status
on slave:
mysql show slave status;
+-+-+-+---+
Apparently I had list File permissions with my user. Thanks anyway.
-James
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Replication Problem
Hello,
I have this replication problem. I am getting
On Thu, 27 Jun 2002 17:37:24 -0700
Patelli Paolo [EMAIL PROTECTED] wrote:
mysql SHOW MASTER STATUS;
++--+--+--+
| File | Position | Binlog_do_db | Binlog_ignore_db |
++--+--+--+
1 - 100 of 124 matches
Mail list logo