Unix Technical Forum

RE: Replication problem

This is a discussion on RE: Replication problem within the MySQL General forum forums, part of the MySQL category; --> I'm sorry. I have posted a wrong example. Here you have a better one: update table_1 \n set field_1 ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:59 AM
=?iso-8859-1?Q?Jorge_Mart=EDnez?=
 
Posts: n/a
Default RE: Replication problem


I'm sorry. I have posted a wrong example. Here you have a better one:

update table_1 \n
set field_1 = 'xx', \n
field_2 = 'yy'; \n > Date: Tue, 21 Aug 2007 11:16:50 -0400> From: baron@xaprb.com> To: oblacks@hotmail.com> CC: mysql@lists.mysql.com> Subject: Re: Replication problem> > Hi,> > Jorge Martínez wrote:> > We havea windows server running our main database and an IIS server. We also havea 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 were replicated properly. We find out that some queries that come from the linux box and have cr/lf on them arenot being replicated.> > > > ie: sql = "select * from table_1";> > SELECT queries are not replicated. Only queries that change data are > replicated.> > > > > I think that may be some issues about how linux manages cr/lf. Whan can I do?> > > > thank you all!> > __________________________________________________ _______________> > Consigue el nuevo Windows Live Messenger>> http://get.live.com/messenger/overview> > > -- > MySQL General Mailing List> For list archives: http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/mysql?unsub=oblacks@hotmail.com>
__________________________________________________ _______________
Llama a tus amigos de PC a PC: ˇEs GRATIS!
http://get.live.com/messenger/overview
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:30 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com