On Thursday 13 February 2003 16:43, Johannes Ullrich wrote: > I am having problems setting up replication between two 4.0.10 > servers. > > What I did so far: > > - generate a dump of the current state of the server using > 'mysqldump' (its a mix of mostly innodb tables and some MyISAM > tables) > - dropped all databases from the slave > - imported the dump into the slave using > mysql < dump > - updated the slave parameters using 'CHANGE MASTER' > > As I start the slave, it immediatly stops and I am getting the > following in the slave error log: > > > 030213 4:36:30 Slave I/O thread: connected to master 'repl@master:3399', > replication started in log 'slave-bin.005' at position 86967189 030213 > 4:36:30 Error updating slave list: Query error > 030213 4:36:30 Slave I/O thread exiting, read up to log 'slave-bin.005', > position 86967189 > > not that the master is running on port 3399 (ssh tunnel). > I can connect to the master as 'repl' from the slave. > looking at the source shows this error in conjunction with > 'show slave hosts'. This command returns an empty result on > master and host. Not sure what it is supposed to return. > > I did try a 4.0.5 master first with the same result. Now I upgraded > the master to 4.0.10 (slave ran 4.0.10 all along).
Check the user 'repl' has REPLICATION SLAVE privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php