Hello All, I set up replication between 2 servers recently. I just need one db to be replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: tallydb,tallydb Now the problem is that there is another db named tallydbopextblob and the tables from this db are also getting replicated as shown in the below line. Last_Error: Error 'Table 'tallydbopextblob.TBL_EVAL_PITEM_OP_EXT_DETAILS' doesn't exist' on query. Default database: 'tallydb'. Query: 'INSERT INTO tallydbopextblob.TBL_EVAL_PITEM_OP_EXT_DETAILS( FLD_OP_INPUT_DATA,FLD_OP_INDEX_DATA1,FLD_OP_INSTANCE_ID) VALUES('type=FPCONNECT&source=TALLY&request_type=ACTIVATION&offline_flag=0&serial=372123675&major_version=7&minor_version=2&major_release=3&minor_release=14&build_num=rel7.2_3.14_2007-05-21_19.33&platform=WIN&os=WIN&user_name=server&host_name=SERVER&lic_ver=2&fingerprint63=1mQ0nE8HkaBlNRg==aa,3GAwmgzLMbCGNJyMyaa,3GAwmgzLMbCGNJyMyaa,2NDkxODk0MjUyAA==&finger_print=5qZEKE5HgchxNpnOZ3GyZaa&server_id=0&activation_code ... Why is this happening? Thanks & regards, Ratheesh