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?
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
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
