I think that's a very valid question. To me it seems like it has been asked before, but never really been answered.
Let me rephrase the question and tell me it's still what you're asking:
What is the best way to connect a filemaker database to a MySQL database on the web? I want to keep the local FM database, but I also want a recent, periodically updated copy of my data accesible on a remote webserver. I also want to filter which tables are being transfered.
Here's what I got so far, but I warn you, I'm a FM noob:
We want to have FM write its data not only to its own local database, but ALSO to a LOCAL MySQL db first. I have yet to figure out the steps how to do that.
Next step should be easy: Syncing a local MySQL db with the one on the remote webserver can easily be done by MySQL REPLICATION.
Thanks.