REPLICATION PROBLEM ON 4.0.14 (see prevoius e-mail)

2003-08-25 Thread Massimo Petrini
When the 4.0.15 version will be avalaible ? The problem fo replication make impossible to install the .14 version and I came back to .13 release. Best regards Massimo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Replication Problem (XP+mysql4.0.14)

2003-08-22 Thread I.P.
Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my configuration: ### FOR MASTER # # This will be passed to all mysql clients [client]

Re: Replication Problem (XP+mysql4.0.14)

2003-08-22 Thread Massimo Petrini
, August 22, 2003 11:56 AM Subject: Replication Problem (XP+mysql4.0.14) Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my configuration: ### FOR MASTER

Replication Problem - Sorry

2003-08-20 Thread ed
I should appologize for my earlier post Another Replication Problem. I had not properly analyzed the problem before posting. Although I have been administering a MySQL database for about a year now, replication is completely new to me. Sorry if I wasted anyone's time. Thanks to Jeremy

Another Replication Problem

2003-08-19 Thread ed
I am having another problem with replication in mysql 4.0.13. The slave server crashed and upon re-starting there was a new relay-bin log file created and the old relay-bin log file remained. MySQL, however seemed to be stuck on the old one. The slave reported to be running fine according to

Re: Another Replication Problem

2003-08-19 Thread Jeremy Zawodny
On Tue, Aug 19, 2003 at 02:51:28PM -0400, [EMAIL PROTECTED] wrote: I am having another problem with replication in mysql 4.0.13. The slave server crashed and upon re-starting there was a new relay-bin log file created and the old relay-bin log file remained. Right. It needs to finish with

[kapper.net #16695] Re: Another Replication Problem

2003-08-19 Thread general
Hallo User, diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt Dir die Uebernahme in unser Bearbeitungssystem. Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte

[kapper.net #16695] Re: Another Replication Problem

2003-08-19 Thread info via RT
Hallo User, diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt Dir die Uebernahme in unser Bearbeitungssystem. Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte

Replication Problem

2003-08-18 Thread ed
I am having a problem with replication in MySQL 4.0.13. I have a my.cnf file in the data directory of the slave that should exclude a specific table in one of my databases from replication. I am getting the following error message: error 'unexpected success or fatal error' on query 'UPDATE

RE: Replication Problem

2003-08-18 Thread Dathan Vance Pattishall
to be inconsistent or you can recover from the possible skipped slave event. ---Original Message- --From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] --Sent: Monday, August 18, 2003 2:51 PM --To: [EMAIL PROTECTED] --Subject: Replication Problem -- -- --I am having a problem with replication in MySQL

Re: replication problem

2003-08-14 Thread Andy Smith
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

Re: replication problem

2003-08-14 Thread Andy Smith
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

Re: replication problem

2003-08-14 Thread Andy Smith
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

Re: replication problem

2003-08-14 Thread Andy Smith
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).

Re: Replication Problem...

2003-08-14 Thread Victoria Reznichenko
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

Replication Problem...

2003-08-14 Thread System
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= 3306 socket =

Re: replication problem

2003-08-11 Thread walt
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

Re: replication problem

2003-08-10 Thread Andy Smith
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

Re: replication problem

2003-08-09 Thread Andy Smith
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

Re: replication problem

2003-08-08 Thread Steven Roussey
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

Re: replication problem

2003-08-08 Thread Andy Smith
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

replication problem

2003-08-06 Thread Andy Smith
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 have set up a master and a slave according to the manual. The master runs 4.0.12 and the slave runs 4.0.14, they are both actually on the same machine

Re: replication problem

2003-08-06 Thread walt
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

Re: replication problem

2003-08-06 Thread Andy Smith
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

Re: replication problem

2003-08-06 Thread walt
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

Replication problem

2003-08-03 Thread Ganbold
Hi, I'm using MySQL 4.0.13 for both master and slave servers. However I have problem starting slave server. Error log says: 030804 14:06:10 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'backend2-bin.228' at position 43583528 030804 14:11:48 Slave

Re: replication problem

2003-07-31 Thread greg
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

Re: replication problem

2003-07-30 Thread Jonathan Fowler
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]

Replication Problem

2003-07-28 Thread MaFai
Hello, mysql, 1 master and 1 slave replicated successfully. After I change the master IP address. So the slave can not replicate the master data. Then I type change master to 'new ip'. Show slave status show that an error log found. How can I slove this? Log: mysql show slave status\G

replication problem

2003-07-21 Thread Naoufal Rih
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 run in M1, it's replicated in M2 but not in

Re: replication problem

2003-07-21 Thread Egor Egorov
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

Replication Problem

2003-07-18 Thread James
First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error

Re: Replication problem: Slave not starting

2003-07-02 Thread gerald_clark
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

Replication problem: Slave not starting

2003-07-01 Thread Andrew Staples
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 replicateuser

replication problem

2003-06-04 Thread Peter Günthner
Hi, i'm trying to replicate two mysql databases (master,slave) but my problem is that the slave don't recognized well my settings because in the err file he shows me: Could not find target log during relay log initialization Note: Failed to initialized master info The master.info exists in the

mysql replication problem

2003-03-04 Thread Floyd Wellershaus
Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the following error message on the slave when I restart. 030303 10:35:28 mysqld started 030303 10:35:29 InnoDB: Started /usr/mysql/libexec/mysqld: ready

Re: mysql replication problem

2003-03-04 Thread Alec . Cawley
] | | cc: | | Subject: mysql replication problem

Re: Replication problem (alter table fails)

2003-02-26 Thread Kirill Peskov (WEB-EU)
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

re: Re: Replication problem (alter table fails)

2003-02-26 Thread Egor Egorov
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

Replication problem (alter table fails)

2003-02-25 Thread Kirill Peskov (WEB-EU)
Dear gurus, 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 into and delete from made on master successfully change the

re: Replication problem (alter table fails)

2003-02-25 Thread Egor Egorov
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

RE: Replication problem (alter table fails)

2003-02-25 Thread Floyd Wellershaus
-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

re: RE: Replication problem (alter table fails)

2003-02-25 Thread Egor Egorov
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

Re: Replication problem

2003-02-14 Thread Phillip Salzman
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.

Replication problem

2003-02-13 Thread Phillip Salzman
Hello, I just setup replication on mysql 3.23.55 and seem to be having some problems. The slave machine does not seem to want to copy all the data on start. I have a table with 54,000 rows on the master, and after I load up the slave there are only 54,850 on that machine. I can drop the

Replication Problem - Droping tmp tables

2003-02-07 Thread Luc Foisy
Here are a number of queries that are run from time to time on the master. They are always run together and in order that they appear. Version of the server is 3.23.32 ( yes its old, but difficult to update at this time ) Version of the slave is 3.23.49a Note: [param:variable] is handled by our

mysql replication problem

2003-01-14 Thread Vaso Koutsonikola
Hi, I am replicating a table between 2 servers. The table on the master executes many transactions that should be replicated to the table on the slave.. The table on the slave is only readable... I have noticed that the changes on the master are not replicated at once but it takes about 2 hours to

Re: mysql replication problem

2003-01-14 Thread walt
Vaso Koutsonikola wrote: Hi, I am replicating a table between 2 servers. The table on the master executes many transactions that should be replicated to the table on the slave.. The table on the slave is only readable... I have noticed that the changes on the master are not replicated at

replication problem

2002-12-03 Thread Gil Shai
Hi I am using replication with MyISAM tables with MySQL. I want to check once in a while that the master and slave are synchronized through software. Is there an elegant way of doing it except for using SHOW MASTER STATUS with the file name and pointer? Thanks Gil Shai Savantis Systems  

Mysql replication problem

2002-11-23 Thread Vaso Koutsonikola
Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013) Then the slave reconnects to the master and the replication

Re: Mysql replication problem

2002-11-23 Thread Gerald R. Jensen
] To: [EMAIL PROTECTED]; Vaso Koutsonikola [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 1:10 PM Subject: Mysql replication problem Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. Error reading packet from server: Lost

Replication problem with update queries

2002-11-22 Thread RAHARD Matthieu
Hello, 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. When I make an update on an existant row in a table on the

re: Replication problem with update queries

2002-11-22 Thread Egor Egorov
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.

re: replication problem

2002-09-24 Thread Victoria Reznichenko
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,

RE: replication problem

2002-09-24 Thread David Piasecki
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

replication problem

2002-09-23 Thread David Piasecki
We are having a problem which seems to have appeared recently with replication on our mysql servers. - We have 3 servers set up with mysql 3.23.52 (they were running .49 but we upgraded in an attempt to fix this problem, which did not work), set up as a master and 2 slaves to the master. -

RE: Replication problem: slave can't log into master

2002-09-09 Thread Jamie Beu
/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

Re: Replication problem: slave can't log into master

2002-09-08 Thread Jeremy Zawodny
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

RE: Replication problem: slave can't log into master (update)

2002-09-06 Thread Jamie Beu
: 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

Replication problem: slave can't log into master

2002-09-05 Thread Jamie Beu
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 Slave thread: error connecting to master: Access denied for user:

Replication problem: slave can't log into master (update)

2002-09-05 Thread Jamie Beu
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: mysql -hctiadb1 -urepl -preplctia and can access whatever database I wish. I

Re: Replication problem: slave can't log into master (update)

2002-09-05 Thread Dicky Wahyu Purnomo
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:

Replication problem

2002-08-21 Thread B.L. Choy
Description: Replication cannot be started How-To-Repeat: Following the set up instructions in section 4.10 Replication in MySQL of the MySQL documentation Fix: Not known Submitter-Id: Originator:B.L. Choy Organization: MySQL support: none Synopsis:

Re: replication problem

2002-08-21 Thread Froilan Mendoza
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

replication problem

2002-08-20 Thread Froilan Mendoza
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 followed the steps in the manual but

Re: replication problem

2002-08-20 Thread walt
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

Re: replication problem

2002-08-20 Thread Froilan Mendoza
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;

Re: replication problem

2002-08-20 Thread walt
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; +-+-+-+---+

Replication Problem

2002-08-16 Thread James Kelty
Hello, I have this replication problem. I am getting this error on the slave: 020816 16:30:49 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 020816 16:30:49 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4

RE: Replication Problem

2002-08-16 Thread James Kelty
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

Replication problem on MySQL

2002-08-13 Thread cpandian
I'm using MySQL 3.23.38 as master and MySQL 3.23.49 as a slave in a simple replication. I configured the system as the manual said, using the default bin-log on the master (www-bin.001) The problem is that every night (at 5:00) the replication stops. The master.info file on the slave server

Re: 4.0.2 Replication problem w/ AUTO_INCREMENT columns?

2002-07-27 Thread Heikki Tuuri
] Newsgroups: mailing.database.mysql Sent: Saturday, July 27, 2002 4:15 AM Subject: 4.0.2 Replication problem w/ AUTO_INCREMENT columns? Hello all, We're experiencing a bit of difficulty replicating from a 4.0.2 master on Linux to a 4.0.2 slave on Linux. Most of our tables, including the one

4.0.2 Replication problem w/ AUTO_INCREMENT columns?

2002-07-26 Thread Jon Frisby
Hello all, We're experiencing a bit of difficulty replicating from a 4.0.2 master on Linux to a 4.0.2 slave on Linux. Most of our tables, including the one that's giving us headaches are InnoDB. My colleague encountered the problem, his description follows: It seems to barf on auto_increment

replication problem

2002-07-17 Thread massimo . ferrario
Description: I am testing the replication of one database from this host to a slave MySQL server. Some of the queries that ALTER a table structure are not replicated to the slave, causing a stop of the replication. I said some because while I was troubleshooting

Replication Problem with Temp tables

2002-07-13 Thread Bill MacAllister
Hello, My MySQL slave (3.23.51) stopped with the error: Last_errno: 1146 Last_error: error 'Table 'bts.tmp_na' doesn't exist' on query 'insert into name_address select * from tmp_na ' It is possible that this occured because of inopportune timing in stopping and restarting of the slave.

Replication problem

2002-06-27 Thread Patelli Paolo
Hi, I'm trying to replicate a db. I'm running MySQL 3.23.49a-log on a linux box as master and MySQL 3.23.49-log on Solaris as slave. I copied the data on the solaris box and I modified the cnf files. The slave error message is the following: 020627 16:04:35 Slave: Failed reading log event,

Re: Replication problem

2002-06-27 Thread Dicky Wahyu Purnomo
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 | ++--+--+--+

Replication problem

2002-06-14 Thread Sbastien DIDIER
Hi, I used replication as a real-time backup for months and I'am now trying to configure a two-way replication between two MySQL servers (srv1 and srv2). So, srv1 replicates from srv2 and srv2 replicates from srv1 (They are both master and slave). The One-way replication is working fine from

RE: Replication problem Timeout in MySQL

2002-06-14 Thread Sbastien DIDIER
Ok. So i'm a bit confused with all the timeout values. My replication process is killed because of a net_read_timeout which is 30 secondes . I think there's at least three different timeouts : net_read_timeout : The process will be killed if it doesn't receive data during net_read_timeout secs.

Re: replication problem

2002-06-06 Thread Frederic Dhorne
: replication problem i am sending it again, maybe this time someone would help ... :) hello, i have major problem with setting up replication. both ends are running mysql 3.23.49 i have set up proper entries in my.cnf on both sides and have replicated the dbs. slave's data directory

RE: replication problem

2002-06-03 Thread Terry
Hello, More than likely you have missed the step that the slave database has to be the exact one that the master has before the start of the binlog. Shutdown both servers, grab a copy of the master's data directory and tar that up, move that to the slave, delete the slave's current data

replication problem

2002-05-31 Thread Bartomiej Dolata
hello, i have major problem with setting up replication. both ends are running mysql 3.23.49 i have set up proper entries in my.cnf on both sides and have replicated the dbs. now, on master: show master status reads: ++--+--+--+ | File

Re: replication problem

2002-05-31 Thread Scott Helms
that is done test replication by going to the master and creating a database, then check on the slave to ensure its there with a show databases. Scott Helms - Original Message - From: Bartomiej Dolata [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 31, 2002 7:59 AM Subject: replication

Re: Replication problem

2002-05-27 Thread Benjamin Pflugmann
Hi. As I have seen no answer yet, just a wild guess: Maybe you have some query which used both databases, something like INSERT INTO fdf.whatever SELECT FROM access.pagespromo ... You can always use the binlog utilities and have a look at the query which caused the failure. Regards,

Replication problem

2002-05-23 Thread vlady
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my replication server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted.

Replication problem

2002-05-23 Thread vlady
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

replication problem

2002-05-23 Thread vlady
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

Replication problem

2002-05-14 Thread Dicky Wahyu Purnomo
Hi, I have short question ... my mysql daemon sometimes restarted ... and the error message like this : 020429 11:19:36 Slave: connected to master '[EMAIL PROTECTED]:3306', replica tion started in log 'austria_replication.048' at position 95670800 mysqld got signal 11; This could be because

Replication Problem

2002-05-10 Thread Raymond Brighenti
Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections 020509 18:58:52 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec 020509 18:59:54 Slave

Re: Replication Problem

2002-05-10 Thread Terrence Cox
: Raymond Brighenti [EMAIL PROTECTED] Date: Fri, 10 May 2002 10:23:30 +0100 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: Replication Problem Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections

RE: Replication Problem

2002-05-10 Thread Luc Foisy
master -Original Message- From: Raymond Brighenti [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 5:24 AM To: '[EMAIL PROTECTED]' Subject: Replication Problem Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql

RE: Replication Problem

2002-05-10 Thread Luc Foisy
:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 5:24 AM To: '[EMAIL PROTECTED]' Subject: Replication Problem Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections 020509 18:58:52 Slave thread: error connecting

RE: Replication Problem

2002-05-10 Thread Raymond Brighenti
wouldn't be able to use it as a slave otherwise. Very strange, any other things to try? Ray -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 2:24 To: 'Raymond Brighenti'; MYSQL-List (E-mail) Subject: RE: Replication Problem actually you may want to change

RE: Replication Problem

2002-05-10 Thread Luc Foisy
PROTECTED]' Subject: RE: Replication Problem Hi, I tried using a FreeBSD box with MySQL as the Master and W2K as the slave and it works fine. I then swapped it so the W2K was master and I get the following from the Unix box. 020510 14:14:22 mysqld started /usr/local/libexec/mysqld: ready

Re: Replication Problem

2002-05-10 Thread Jeremy Zawodny
On Fri, May 10, 2002 at 10:23:30AM +0100, Raymond Brighenti wrote: Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections 020509 18:58:52 Slave thread: error connecting to master:Can't connect to

Replication problem

2002-04-11 Thread Kittiphum Worachat
Hi. I got the problem with replication if I use SQL command LOAD DATA INFILE... to update data in master table the data change to the new one correctly but in slave table nothing happen the data still have the old value. how to solve this problem ?? Kittiphum Worachat,M.T. www.hatyailab.com

Replication problem

2002-02-01 Thread Charitha
Hello all, I am trying to replicate the database in two machines with one master and one slave. I was having the my.cnf entry in the master with the following lines: log-bin= /var/lib/mysql/replication1.log server-id=1 It was working very fine until yesterday evening. But suddenly there

Re: Replication problem

2002-02-01 Thread Hery Yulianto
meet again =-hery=- - Original Message - From: Charitha [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, February 01, 2002 5:57 PM Subject: Replication problem Hello all, I am trying to replicate the database in two machines with one master and one slave. I

Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-10 Thread A. Clausen
07, 2001 21:41 Subject: Re: Replication Problem on MySQL 3.23.45/Win32 At 12:04 07/12/01 -0800, A. Clausen wrote: Hi, Does print the command show databases the db in question ? and you are able for perform commands on the tables using the mysql client tool ? Regards, Miguel I have been using

Re: Replication Problem on MySQL 3.23.45/Win32

2001-12-10 Thread kadvani
Had a question on Whether or not MySQL Editor supports Db2 Version 5.0. Kumud Advani Sears Canada Inc Architect Council - Corporate Data WareHouse Tel : (416) 510 - 6217 - Before posting, please check:

<    1   2   3   >