Hi,
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 tha
manual and some small problems comes up.
May some 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?
Best regards
Thorsten.guddack
---------------------------------------------------------------------
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
