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! ZZ Table2: --- id ! Desc --- 1! xx 2! Xx 4! YY I would like as Result this: --- id ! Desc --- 3! ZZ Thanks for any suggestions. Massimiliano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: R: Replication stopped without reason
After 60~120 secs the replication stopped. Setting the parameter Connect-rety to 30 secs doesn't change the situation: the slave lose the connection and the replication is stopped. Massi -Messaggio originale- Da: Egor Egorov [mailto:[EMAIL PROTECTED] Inviato: venerdì 25 luglio 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 "without result"? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: Replication stopped without reason
YesThe replication stopped in the next 60 secs. I've tried to change connect-retry to 30 secs without result. :-/ Max -Messaggio originale- Da: Dominicus Donny [mailto:[EMAIL PROTECTED] Inviato: giovedì 24 luglio 2003 11.36 A: [EMAIL PROTECTED] Oggetto: Re: Replication stopped 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: <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 3:38 PM Subject: 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 connected with a cdn. > > What can i do for stabilize the replication?? > > Massimiliano > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 connected with a cdn. What can i do for stabilize the replication?? Massimiliano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 'webserver-bin.054' at position 73 030710 22:38:53 Error reading packet from server: (server_errno=0) 030710 22:38:53 Slave thread killed while reading event 030710 22:38:53 Slave thread exiting, replication stopped in log 'webserver-bin.054' at position 1120 030710 22:38:58 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.054' at position 1120 *** I've tried to do also Reset master On the master before lock tables without result Any suggestion?? The server and the slave are mysql 3.23.56 Massimiliano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Impossible query??
Hi, sorry for my bad english. I've a table where i store the result of a quality test. If the test is passed then the result=ok and connect=0 If test fail then result=nok and, if it's the first test for the product, connect=0 When i retest a failed product i've connect= previous testid of the product failed It's possible to do a query for print the history of one id?? Exemple mysql> select * from mytable; +-+--+--+ | testId | connect | result | +-+--+--+ | 1 | 0| ok | | 2 | 0| nok | | 3 | 2| nok | | 4 | 3| nok | | 5 | 0| ok | | 6 | 4| nok | | 7 | 6| ok | | 8 | 0| ok | +-+--+--+ I want the history of testId=7 mysql> ?? +-+--+--+ | testId | connect | result | +-+--+--+ | 7 | 6| ok | | 6 | 4| nok | | 4 | 3| nok | | 3 | 2| nok | | 2 | 0| ok | +-+--+--+ Thanks a lot! Max (trashman) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: R: R: Replication don't work.
The replication now work fine. I've deleted from my.ini on MASTER binlog-do-db=database_name I've tried to insert in my.ini on SLAVE replicate-ignore-table=db_name.table_name Without result. If i insert any option (replicate-ignore-table or binlog-do-db) the replica is stopped!! :-/ A little question: the replica will stop also if i write in a new db on slave? Massi -Messaggio originale- Da: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Inviato: martedì 1 aprile 2003 14.04 A: [EMAIL PROTECTED] Oggetto: re: R: R: Replication don't work. On Tuesday 01 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 webserver-bin.010 is not updated. > > I've tried to do the operation > > >SET SQL_LOG_BIN = 1 > > But the result is the same. > > What can i do now?? Do you use binlog-do-db/binlog-ignore-db options? -- .com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: R: Replication don't work.
Sorry for my mails, but i'm blocked with my work from several days. Last info about my problem. The webserver.bin is not updated after insert operation in db. I've found a Delayed_insert... If i do on the master >SHOW PROCESSLIST; ++--+-+--++- -+-+--+ | Id | User | Host| db | Command| Time | State | Info | ++--+-+--++- -+-+--+ | 2 | baldomax | localhost | NULL | Sleep | 2|| NULL | | 6 | ODBC | localhost | zope | Query | 0| N | show processlist | | 17 | ODBC | localhost | zope | Sleep | 720 || NULL | | 18 | ODBC | localhost | zope | Sleep | 28 || NULL | | 19 | ODBC | localhost | zope | Sleep | 24 || NULL | | 24 | repl | ppp-X.inwind.it | NULL | Binlog Dump| 257 | Slave connection: waiting for binlog update | NULL | | 25 | DELAYED | localhost | zope | Delayed_insert | 129 | Waiting on cond| log | ++--+-+--++- -+-+--+ 7 rows in set (0.00 sec) Massi -Messaggio originale- Da: trashMan [mailto:[EMAIL PROTECTED] Inviato: martedì 1 aprile 2003 11.31 A: [EMAIL PROTECTED] Oggetto: R: R: Replication don't work. 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 webserver-bin.010 is not updated. I've tried to do the operation >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. Master.err MySql: Pronto per le connessioni (ready for connection) Slave.err 030401 1:04:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.010' at position 73 Master.info of slave webserver-bin.010 73 xx.xx.xx.x replica pwdreplica 3306 60 My.ini of master [mysqld] skip-innodb basedir=C:/mysql datadir=C:/mysql/data log-bin server-id=1 language=C:/mysql/share/italian binlog-do-db=Zope My.ini of slave [mysqld] skip-innodb port=3306 language=c:/programmi/mysql/share/italian server-id=12 master-host=xx.xx.x.xx master-user=replica master-password=pwdreplica 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 work. Massi, You will get much better results if you provide the following: Copies of: my.cnf file from both master and slave (look in $MYSQL/data or /etc) $HOSTNAME.err logs from master and slave master.info file from slave (look in $MYSQL/data directory) and check that one does not exist on the master, this gave me fits for several hours one day while moving a slave to being the master when the then current master died of a bad hard drive. No guarantees, but this will greatly improve your chances of an intelligent answer. ;p Scott Helms On Mon, 2003-03-31 at 17:04, trashMan wrote: > The error.log on the master dont' report anything... > > MySql: ready for connections > > Other info > > >Show master status; > > *** > Headeranswer note > *** > File webserver-bin.008 > Position 73 > > > > >SHOW PROCESSLIST > > *** > Header answer > *** > User userreplica > Host X > Db NULL > Command Binlog dump > Time (the time passed from the mysql > start) > Queryconnect > Time (the time passed from the mysql > Stateslave connection: waiting for binlog update > > > :-/ > > Massi > > > > > > -Messaggio originale- &
R: R: Replication don't work.
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 webserver-bin.010 is not updated. I've tried to do the operation >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. Master.err MySql: Pronto per le connessioni (ready for connection) Slave.err 030401 1:04:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.010' at position 73 Master.info of slave webserver-bin.010 73 xx.xx.xx.x replica pwdreplica 3306 60 My.ini of master [mysqld] skip-innodb basedir=C:/mysql datadir=C:/mysql/data log-bin server-id=1 language=C:/mysql/share/italian binlog-do-db=Zope My.ini of slave [mysqld] skip-innodb port=3306 language=c:/programmi/mysql/share/italian server-id=12 master-host=xx.xx.x.xx master-user=replica master-password=pwdreplica 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 work. Massi, You will get much better results if you provide the following: Copies of: my.cnf file from both master and slave (look in $MYSQL/data or /etc) $HOSTNAME.err logs from master and slave master.info file from slave (look in $MYSQL/data directory) and check that one does not exist on the master, this gave me fits for several hours one day while moving a slave to being the master when the then current master died of a bad hard drive. No guarantees, but this will greatly improve your chances of an intelligent answer. ;p Scott Helms On Mon, 2003-03-31 at 17:04, trashMan wrote: > The error.log on the master dont' report anything... > > MySql: ready for connections > > Other info > > >Show master status; > > *** > Headeranswer note > *** > File webserver-bin.008 > Position 73 > > > > >SHOW PROCESSLIST > > *** > Header answer > *** > User userreplica > Host X > Db NULL > Command Binlog dump > Time (the time passed from the mysql > start) > Queryconnect > Time (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 don't work. > > > It the master actually writting to the binlog? What does the master > say when you run SHOW MASTER STATUS? Is the size of the binlog > growing? > > -Original Message- > From: trashMan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 1:29 PM > To: [EMAIL PROTECTED] > Subject: 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 > *** > Slave_Running YES > Last_Error none > > > >SHOW PROCESSLIST > > *** > Header answer > *** > User system user > Host none > Db NULL > Queryconnect > Time (the time passed from the mysql > start) > StateReading master update > > > I think the database is in updating...but the table are the samei > don't have new data!! What can i do??? :-( > > Help! > > Massi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: trashMan; [EMAIL PROTECTED] Oggetto: RE: Replication don't work. What position and in what binlog does your slave show it is at? It might be helpful if you post the entire output of show slave status (minus user and host if you are concerned about that for some reason). -Original Message----- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:04 PM To: 'Jennifer Goodie'; [EMAIL PROTECTED] Subject: R: Replication don't work. The error.log on the master dont' report anything... MySql: ready for connections Other info >Show master status; *** Headeranswer note *** File webserver-bin.008 Position 73 >SHOW PROCESSLIST *** Header answer *** User userreplica Host X Db NULL Command Binlog dump Time (the time passed from the mysql start) Queryconnect Time (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 don't work. It the master actually writting to the binlog? What does the master say when you run SHOW MASTER STATUS? Is the size of the binlog growing? -Original Message- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 1:29 PM To: [EMAIL PROTECTED] Subject: 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 *** Slave_Running YES Last_Error none >SHOW PROCESSLIST *** Header answer *** User system user Host none Db NULL Queryconnect Time (the time passed from the mysql start) StateReading master update I think the database is in updating...but the table are the samei don't have new data!! What can i do??? :-( Help! Massi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: R: Replication don't work.
Sigh. Master.err 030401 1:14:42 MySql: Forzata la chiusura del thread 13 utente: 'titti' 030401 1:14:42 MySql: Forzata la chiusura del thread 12 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 11 utente: 'geofor' 030401 1:14:42 MySql: Forzata la chiusura del thread 5 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 2 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 1 utente: 'massi' 030401 1:14:42 MySql: Shutdown completato MySql: Pronto per le connessioni (ready for connection) Slave.err 030401 1:04:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.010' at position 73 Master.info of slave webserver-bin.010 73 xx.xx.xx.x replica pwdreplica 3306 60 My.ini of master [mysqld] skip-innodb basedir=C:/mysql datadir=C:/mysql/data log-bin server-id=1 language=C:/mysql/share/italian binlog-do-db=Zope My.ini of slave [mysqld] skip-innodb port=3306 language=c:/programmi/mysql/share/italian server-id=12 master-host=xx.xx.x.xx master-user=replica master-password=pwdreplica 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 work. Massi, You will get much better results if you provide the following: Copies of: my.cnf file from both master and slave (look in $MYSQL/data or /etc) $HOSTNAME.err logs from master and slave master.info file from slave (look in $MYSQL/data directory) and check that one does not exist on the master, this gave me fits for several hours one day while moving a slave to being the master when the then current master died of a bad hard drive. No guarantees, but this will greatly improve your chances of an intelligent answer. ;p Scott Helms On Mon, 2003-03-31 at 17:04, trashMan wrote: > The error.log on the master dont' report anything... > > MySql: ready for connections > > Other info > > >Show master status; > > *** > Headeranswer note > *** > File webserver-bin.008 > Position 73 > > > > >SHOW PROCESSLIST > > *** > Header answer > *** > User userreplica > Host X > Db NULL > Command Binlog dump > Time (the time passed from the mysql > start) > Queryconnect > Time (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 don't work. > > > It the master actually writting to the binlog? What does the master > say when you run SHOW MASTER STATUS? Is the size of the binlog > growing? > > -Original Message- > From: trashMan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 1:29 PM > To: [EMAIL PROTECTED] > Subject: 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 > *** > Slave_Running YES > Last_Error none > > > >SHOW PROCESSLIST > > *** > Header answer > *** > User system user > Host none > Db NULL > Queryconnect > Time (the time passed from the mysql > start) > StateReading master update > > > I think the database is in updating...but the table are the samei > don't have new data!! What can i do??? :-( > > Help! > > Massi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: Replication don't work.
The error.log on the master dont' report anything... MySql: ready for connections Other info >Show master status; *** Headeranswer note *** File webserver-bin.008 Position 73 >SHOW PROCESSLIST *** Header answer *** User userreplica Host X Db NULL Command Binlog dump Time (the time passed from the mysql start) Queryconnect Time (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 don't work. It the master actually writting to the binlog? What does the master say when you run SHOW MASTER STATUS? Is the size of the binlog growing? -Original Message- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 1:29 PM To: [EMAIL PROTECTED] Subject: 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 *** Slave_Running YES Last_Error none >SHOW PROCESSLIST *** Header answer *** User system user Host none Db NULL Queryconnect Time (the time passed from the mysql start) StateReading master update I think the database is in updating...but the table are the samei don't have new data!! What can i do??? :-( Help! Massi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 *** Slave_Running YES Last_Error none >SHOW PROCESSLIST *** Header answer *** User system user Host none Db NULL Queryconnect Time (the time passed from the mysql start) StateReading master update I think the database is in updating...but the table are the samei don't have new data!! What can i do??? :-( Help! Massi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 in one other local tablebut the question is: can i write another table in the database? Must i create another database or it's impossible because the sync is about all data and not referred on a single db? Massi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: trashMan; [EMAIL PROTECTED] Oggetto: RE: Replication error 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 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:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks Massimiliano and samuela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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:running SHOW PROCESSLIST on SLAVE return reconnecting after a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks Massimiliano and samuela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 a failed read Any suggestion about this?? Please, help me! I don't know what can i do! The master and the slave are not in the same network: the master is a server located in a webfarm and the slave is my pc. If i try to connect me to mysql MASTER from my pc via mysql --host= --user=userforreplica --password=pwdforreplica i enter but i can not do nothing. Thanks and...sorry for my bad english Massimiliano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php