I am trying to use MySQL federated tables. The problem is that the documentation specified at http://dev.mysql.com/doc/refman/5.0/en/federated-use.html says that a federated table should be created using the following format for the CONNECTION parameter:

scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name

E.G.

CONNECTION='mysql://username:password@hostname:port/database/tablename'
CONNECTION='mysql://username@hostname/database/tablename'
CONNECTION='mysql://username:password@hostname/database/tablename'

The problem is that the table I am trying to connect to has non-standard characters in it and I cannot find the proper way to scape them in the connections tring.

For example, a table named `Table (one)` . Which has the space and the parenthesis, requiring backticks surrounding it inside any SQL code.

Anyone know the proper way to do this?