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