master, slave replication for mysql and vbulletin 3.8.2
 

Hi,

I'm trying to setup database replication for a vBulletin 3.8.2 and I'm getting some errors on preventing tmp tables from being replicated.

[slave /etc/my.cnf]
.. login stuff
binlog_do_db = vBulletin

# ignore replication for some memory tables
replicate-ignore-table=vBulletin.vbb_cpsession
replicate-ignore-table=vBulletin.vbb_session
replicate-wild-ignore-table=vBulletin.vbb\__aggregate\_temp\_%

[master /etc/my.cnf]
binlog_do_db = vBulletin
....

show slave status:
Last_SQL_Error: Error 'Table 'vBulletin.vbb_taggregate_temp_1384941360' doesn't exist' on query. Default database: 'vBulletin'. Query: 'UPDATE vbb_thread AS thread,vbb_taggregate_temp_1384941360 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid'

Is there a my.cnf somewhere that I can check for a proper master, slave replication for vBulletin?

Thanks

.vbb_taggregate_temp_1384941360' those are temp files created when you've had a table crash or database error, you can delete those.