scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name
CONNECTION='mysql://mysql@remote_server:3306/remote/TEST00'
[root@localhost var]# ls Federated_TEST/ TEST00.frm
mysql> show table status \G; ************ 1. row **************** Name: TEST00 Engine: FEDERATED Version: 10 Row_format: Fixed Rows: 100000 Avg_row_length: 148 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update_time: 1970-01-01 09:33:26 Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: