After some search-engine help and a lot of floundering around here is what I found. Maybe not all steps are necessary. Maybe they are.
In My.cnf (add and commented out):
[mysqld]
federated
#skip-federated
Reinstall xampp.
Reboot.
======
This got FEDERATED installed. However, the first times I tried to create a FEDERATED table from phpAdmin, all of the tables in my local database disappeared. Fortunately, they did not disappear in Toad for MySql. I deleted the newly created FEDERATED table and tried again.
The first (unsuccessful times) I used the connection string format: CONNECTION='mysql://fed_user@remote_host:9306/federated/test_table'; per the example in the MySql documentation (
http://dev.mysql.com/doc/refman/5.1/en/ ... ction.html).
My successful connection string format was: CONNECTION='mysql://fed_user:password@remote_host:3306/federated/test_table';
NOTE: When I later changed the structure of the remote table, all of the tables in the local phpAdmin display again disappeared until I deleted the FEDERATED table pointing to the changed remote table (using Toad for MySql). This didn't always happen but it was startling at first and is still annoying. More than likely there is a logical explanation.
Hope this helps someone.
+Les