[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Replication Problems/Questions
From:       Guddack Thorsten ICM MP SCM GO 21 <thorsten.guddack () siemens ! com>
Date:       2003-01-31 19:52:31
[Download RAW message or body]



-----Ursprüngliche Nachricht-----
Von: Guddack Thorsten ICM MP SCM GO 21 
Gesendet: Freitag, 31. Januar 2003 20:51
An: 'Gelu Gogancea'; 'mysql@list.mysql.com'
Betreff: Re: Replication Problems/Questions


Hi,
thank you for you're response,
but in the mysql-manual > version 4.0 they said that the Problems with load
data, load data infile have been solved.

So I'm a little bit confused about that.

Best regards


-----Ursprüngliche Nachricht-----
Von: Gelu Gogancea [mailto:ggelu@arctic.ro]
Gesendet: Donnerstag, 30. Januar 2003 20:48
An: Guddack Thorsten ICM MP SCM GO 21; mysql@lists.mysql.com
Betreff: Re: Replication Problems/Questions


Hi,
----- Original Message -----
From: "Guddack Thorsten ICM MP SCM GO 21" <thorsten.guddack@siemens.com>
To: <mysql@lists.mysql.com>
Sent: Thursday, January 30, 2003 3:44 PM
Subject: Replication Problems/Questions


> Hi List
>
> I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
>
> I ve setup a replication between these two servers as discribed in the
> manual and some small problems comes up.
>
> Maybe someone can give me some help.
>
> 1.) On the Master I create a user repl with the rights 'replication
slave'.
>      On the slave I used a user with all possible rights.
>      Starting the replication with 'reset slave', 'change master to.....'
> and 'start slave', I get an error:
>      Show slave status says Slave_IO_running no and some entry in
mysql.err.
>
>      This Problem I could solve using a user in 'change master to ....'
that
> has also admin rights.
>      What could cause the problem?
>
> 2.) The more important Problem:
>      If the replication is running, and I try to replicate a table where
> data was inserted on the master with 'LOAD DATA INFILE...' or
>     'LOAD DATA LOCAL INFILE....' the server process on the slaves
> crushes....
>      The files on the master, for LOAD DATA.....were still there.

>     Any Ideas?
IMHO:
...this can happening because on the slave you don't have(...i guess) the
file for LOAD DATA.By REPLICATION the slave trying to copy every "movement"
of the master and not the data  itself.This means that slave trying to
execute "LOAD DATA INFILE "YOUR_PATH_TO_FILE ".....and not copy the data
from the master.

>
>
> At Last one question:
> - could anyone explain me the meaning of the fields from show slave status
> (  I'm looking for a way to decide if the slave has replicated all the
data
> from the master )
>
> Best regards

Best Regards,

Gelu
>
> thorsten.guddack@siemens.com
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread131223@lists.mysql.com>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@lists.mysql.com>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

---------------------------------------------------------------------
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 <mysql-thread131360@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[prev in list] [next in list] [prev in thread] [next in thread]