<div>
Have each forum periodically download a copy of your master ban list.
</div>


Have each forum periodically download a copy of your master ban list.

<div>
The first things that come to mind are as NovaDenizen suggests having the other servers periodically download the ban list from your 'master' server. &nbsp; Either, using remote connections to the MySQL server do access the data directly, or alternatively you could use a PHP page which simply outputs the ban list then the other servers can open that page, retrieve the list and process it themselves.<br />
<br />
Cheers<br />
<br />
Matt
</div>


The first things that come to mind are as NovaDenizen suggests having the other servers periodically download the ban list from your 'master' server.   Either, using remote connections to the MySQL server do access the data directly, or alternatively you could use a PHP page which simply outputs the ban list then the other servers can open that page, retrieve the list and process it themselves.

Cheers

Matt

<div>
This is rather vague, little more than a restatement of the problem, I was hoping for something more specific. &nbsp;
</div>


This is rather vague, little more than a restatement of the problem, I was hoping for something more specific.  

<div>
<div class="content wysiwyg-content">
I have many different phpbb forums using mysql to hold the data. &nbsp;I frequently have to ban users or whole domains (e.g. youremailsoftware.org) which are used purely by spammers.<br />
<br />
Of course it is not convenient to have to go to every individual forum and use the interface to add the new ban record.<br />
<br />
What way can I keep one master copy and have each other forum somehow get an uptodate copy of the latest?<br />
<br />

</div>
</div>


I have many different phpbb forums using mysql to hold the data.  I frequently have to ban users or whole domains (e.g. youremailsoftware.org) which are used purely by spammers.

Of course it is not convenient to have to go to every individual forum and use the interface to add the new ban record.

What way can I keep one master copy and have each other forum somehow get an uptodate copy of the latest?



Sync phpbb ban table between many different mysql servers

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.