> I need to put a read-only copy of a single table on a database another
> server so remote customers can have read access to it.
I use SQLYob Job Agent to synchronise two MySQL databases. See
http://www.webyog.com/en/ for more information.
I use SSH to so port forwarding from one box to the
This is something I do with replication.
You can replicate a list of tables, see the 'replicate_do_table' config
option.
Then you can euse the 'read_only' option. Replication still works but
nothing else. But it would give you more options by using GRANT instead
of 'read-only':
CREATE US
