All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database an
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote:
> **On Slave Server I replicate database *A alone* and my replication not
> working due to data fetching happen on B database.
>
Well, yes. Statement-based replication does what it says on the box: it
executes the exact same statement on the sla
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of
a User
HI,
first check the error log and find the position where the replication was
terminated.Now run the mysqlbinlog utility on the binarylogs file.
Now when you run the query will get the text format as a result
you need to be sure you have everything the server needs to be a slave
defined in your my.cnf file, especially the relay logs and that the
replication slave user is created properly.
On Tue, Aug 19, 2008 at 2:37 AM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am setting up r
u need to set those parameters
On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Server_id is set but not relay_log and relay_index.
>
> On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>> is the server_id and relay_log and relay_index parameter set in
Server_id is set but not relay_log and relay_index.
On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> is the server_id and relay_log and relay_index parameter set in my.cnf
>
>
> On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> I am setting
is the server_id and relay_log and relay_index parameter set in my.cnf
On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am setting up replication and got the error below
>
> mysql> change master to master_host='172.20.1.189', master_user='repl',
> master_password='pas
Hi Jen,
Jen mlists wrote:
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql"
database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilea
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /root/.mysql/cacert.pem
Master_SSL_CA_Path: /root/.mysql/
Master_SSL_Cert: /root/.mysql/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /root/.mysql/client-key.pem
Seconds_Behind_Mast
"Ugo Bellavance" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>I'm trying to do a replication of two servers (one is mysql version =
> 4.1.0-alpha-debug-debug (slave) on debian and the other is =
> 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for =
> now.
>
> What I've done is
On Wednesday 12 March 2003 20:05, trashMan wrote:
> I've tried to setup a replication but ...i've several problem! I've
> follow the manual istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html
> But the slave don't start the replica.
>
> SHOW SLAVE STATUS on SLAVE return SLAVE:running
>
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [EMAIL PROTECTED]
Subject: Replication error
Please.seven
trashMan wrote:
> Please.seven days to try it!! Help me!! :-(
>
> --
>
> Hello,
> I've tried to setup a replication but ...i've several problem! I've
> follow the manual istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html
> But the slave don't start the replica.
>
> SHOW SL
> Check the user 'repl' has REPLICATION SLAVE privilege.
Ah. that fixed it. Actually, the real reason was that I had not
yet updated the mysql tables and the new privileges did not take
effect as a result.
mysql_fix_privilege_tables , followed by the 'GRANT' command
and 'flush privileges' fixed
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote:
> I am having problems setting up replication between two 4.0.10
> servers.
>
> What I did so far:
>
> - generate a dump of the current state of the server using
> 'mysqldump' (its a mix of mostly innodb tables and some MyISAM
> tab
Hi "Oliver Schlag" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/
Hi list,
My original post concerning this issue is below - it was a week or so ago. No replies
were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have
figured it out, and my slave is now replicating from the master.
The problem was that the mysql data directory wa
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > A
;Jeff Kilbride" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:45 PM
Subject: Re: Replication Error
> RESET MASTER
> RESET SLAVE
>
> Thi
t;mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 12:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > Also, I am intersted in a way to reset the entire replication thing. In
> > other words, just remove all hints of replication an
Lewis Watson wrote:
> Also, I am intersted in a way to reset the entire replication thing. In
> other words, just remove all hints of replication and start over... Is there
> a way I can do this?
> Thanks.
> Lewis
>
> - Original Message -
> From: "Lewis Watson" <[EMAIL PROTECTED]>
> To: "m
Also, I am intersted in a way to reset the entire replication thing. In
other words, just remove all hints of replication and start over... Is there
a way I can do this?
Thanks.
Lewis
- Original Message -
From: "Lewis Watson" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesd
At 01:48 PM 7/12/2002, Jeremy Zawodny wrote:
>On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> > now instead of getting the error every 30 seconds, i get it every
> > hour. is there a way to make it go away forever?
>
>Make the number really big?
>
>I wonder if you can set it to 0 t
On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> i am having the "Error reading packet from server: (server_errno=1159)"
> replication problem.
>
> in searching the archives for others experience replication problems, i
> came across the suggestion of adding these lines to my.cnf
On Wed, Jul 10, 2002 at 03:13:55PM -0700, Jeff Kilbride wrote:
>
> Is there a web-based interface for bug reporting? Or is there a way
> to use the mysqlbug program when my database machine isn't connected
> to the internet?
You can submit a but directly to [EMAIL PROTECTED] If your
message cont
EMAIL PROTECTED]>
Cc: "Nilesh Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 11:39 AM
Subject: Re: Replication - Error reading packet from server:
(server_errno=1159)
> On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
> >
al Message -
From: "Mark Hughes" <[EMAIL PROTECTED]>
To: "Nilesh Shah" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 9:57 AM
Subject: RE: Replication - Error reading packet from server:
(server_errno=1159)
> Thanks, I had a look
On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
> Thanks, I had a look at that and it seems that slave_net_timeout is the
> variable that should be used and this is set to 3600 seconds - however it
> appears that the net_read_timeout is being used and by changing this from
> 30 to 360
Thanks, I had a look at that and it seems that slave_net_timeout is the
variable that should be used and this is set to 3600 seconds - however it
appears that the net_read_timeout is being used and by changing this from
30 to 3600 seconds the messages seem to have gone away.
In the 3.23.38 versio
Set variable net_read_timeout to some bigger value.
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Nilesh Shah
-Original Message-
From: Mark Hughes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 3:36 AM
To: [EMAIL PROTECTED]
Subject: Replication - Error reading packet f
ds,
Bhavin.
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Kannan R" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 22, 2002 9:26 AM
Subject: RE: replication error
> I think somewhere in the manual it warns against runni
I think somewhere in the manual it warns against running slave and master as
different versions.
=C=
-Original Message-
From: Kannan R [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: replication error
On Thu, May 23, 2002 at 10:10:26AM +0530, Kannan R wrote:
>
> I have come across a wierd error in my replication setup..I run
> mysql 3.23.49 on two servers .one is the master and the other the
> slave..I have jus one DB with jus a single table in it. I 'm getting
> the follwoing error on my slav
34 matches
Mail list logo
