I've got a master (Master) with a MERGE table of foo_t (comprising of
bar_a, bar_b, bar_c) in database 'Igloo'.
There are 5 slaves that replicate the Igloo table, but ignore the
Igloo.foo_t table.
This setup was working fine. If the Master server crashed or had a
prblem for some reason, I could always:
STOP SLAVE
RESET SLAVE
FLUSH TABLES
LOAD DATA FROM MASTER
START SLAVE
The Master's motherboard failed last night, and after getting the server
back up, replication seems to be broken. The LOAD DATA FROM MASTER
command fails on ALL slaves with:
mysql> load data from master\g
ERROR 1188 (HY000): Error from master: 'Can't find file: 'foo_t.MRG' (errno: 2)'
mysql>
I've myisamchk'd all the tables on the Master server.
I've dropped the 'foo_t' table and recreated it.
Still get the above error on ALL slaves..
It seems to me there's definitely a problem on the Master server but I'm
just not sure what it is...?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
