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).
--
--------------------------------------------------------------------
[EMAIL PROTECTED] Collaborative Intrusion Detection
join http://www.dshield.org
---------------------------------------------------------------------
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
