On Sat, 8 Apr 2006, Leonardus Setiabudi wrote: > when i log into server 2 using port 3307, i can see the data in db2 > updated, which means the replication succeed (show slave status tells > the same thing), and the same thing with server 3, i can see db3 > updated, also with server 4 where db4 updated > > but when i log into server1, where i can access all the dbs, db2-4 were > never updated (it should be, its the same file) > in this time, if i run repair table on server1 to all tables in db2-4 .. > bingo, the data appears .. > with the info, found xxx rows of 0 rows > > so, to be clear ... server1 is NOT a SLAVE, its just plain server > server2-4 runs well, and replicate well ... the problem lies within > server1, where it supposed to be able to read the FILE (tables) without > the need to issue repair command (at least in my assumption :) )
Hold on, "(it should be, its the same file)", you're saying that db2 on server1 and server2 are using the same database files (datadir)? If that's the case, why? That doesn't make any sense. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
