> 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
I need to put a read-only copy of a single table on a database on another
server so remote customers can have read access to it. I built a new MySQL
server and placed in my DMZ. I can use SSH forwarding to access it from
outside. Now I need to get a copy of the table from my internal MySQL server
t
