OT:select in mysql

Hi, i've a little problem with query. I have two tables where Table1 id desc Table2 id desc I want a list of table1.id not included in Table2 but i don't find the solution! Example Table1: --- id ! Desc --- 1! xx 2! Xx 3

R: R: Replication stopped without reason

2003 10.34 A: [EMAIL PROTECTED] Oggetto: Re: R: Replication stopped without reason "trashMan" <[EMAIL PROTECTED]> wrote: > YesThe replication stopped in the next 60 secs. > > I've tried to change connect-retry to 30 secs without result. > What do you mean

R: Replication stopped without reason

opped without reason Assume you leave the default connect-retry to 60 secs. Is the replication still stopped in the next 60 secs after that? "Me fail English? That's unpossible" ###___Archon___### - Original Message - From: "trashMan" <[EMAIL PROTECTED]> To

Replication stopped without reason

Hi, I've a big problem!!! The replication start and work correctly but after 10 minutes slave don't update anymore. I must do "slave stop - slave start" for restarting replication. In the log there are not error. The slave is connected to internet with a isdn-router while the master is conn

HELP about replication

I've followed the http://www.mysql.com/doc/en/Replication_HOWTO.html but i've this error :-( *** 030710 22:36:43 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webser

Impossible query??

| 6| ok | | 6 | 4| nok | | 4 | 3| nok | | 3 | 2| nok | | 2 | 0| ok | +-+--+--+ Thanks a lot! Max (trashman) --

R: R: R: Replication don't work.

1 April 2003 12:31, trashMan wrote: > I've found the error, but now i must solve it! > The master, when i execute an insert operation in db, don't update the > 'webserver-bin.010'. If i do > > >SHOW MASTER STATUS; > > The pos is the same as before and

R: R: Replication don't work.

iting on cond| log | ++--+-+--++- -+-+--+ 7 rows in set (0.00 sec) Massi -Messaggio originale- Da: trashMan [mailto:[EMAIL PROTECTED] Inviato: martedì

R: R: Replication don't work.

n >SET SQL_LOG_BIN = 1 But the result is the same. What can i do now?? Massi -----Original Message- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 3:19 PM To: 'Scott Helms'; [EMAIL PROTECTED] Subject: R: R: Replication don't work. Sigh.

R: Replication don't work.

The binlog and the pos are the same in master and slave ! Webserver-bin.008 pos 73 Ehmm...i don't know how to save on file the output of show master/slave status -Messaggio originale- Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] Inviato: martedì 1 aprile 2003 0.11 A: tra

R: R: Replication don't work.

ica master-port=3306 basedir=C:/Programmi/mysql/ datadir=C:/Programmi/mysql/data/ replicate-do-db=Zope -Messaggio originale- Da: Scott Helms [mailto:[EMAIL PROTECTED] Inviato: martedì 1 aprile 2003 0.46 A: trashMan Cc: 'Jennifer Goodie'; mysql Oggetto: Re: R: Replication don't

R: Replication don't work.

(the time passed from the mysql Stateslave connection: waiting for binlog update :-/ Massi -Messaggio originale- Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] Inviato: lunedì 31 marzo 2003 23.41 A: trashMan; [EMAIL PROTECTED] Oggetto: RE: Replication

Replication don't work.

There are two weeks i try it...but...the replication don't start!! I've follow the istruction http://www.mysql.com/doc/en/Replication_HOWTO.html without success. In the slave i have: >Show slave status; *** Headeranswer note **

Unidirectional replication

Hi, I've installed a mysql server as master and two other pc with mysql as slave. My application read (a lot) on local and write on server but if the internet connection go down?? I can't write in the local table because the replica is unidirectional sowhat can i do?? I've thinked to write

R: Replication error

SHOW MASTER STATUS on the master say file: webserver-bin.003 Position:11345 Binlog_do_db: zopista Where zopista is the database i want replicate. :-/ Massi & samuela -Messaggio originale- Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] Inviato: giovedì 13 marzo 2003 20.05 A: tras

Replication error

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 SLAVE STATUS on SLAVE return SLAVE:r

Replication error

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 SLAVE STATUS on SLAVE return SLAVE:running SHOW PROCESSLIST on SLAVE return reconnecting after