mysqldump and federated tables

[jvidalcastilla]

Hi!
I'm going to use federated tables to integrate data that is in geographical different locations.
I 've made a database that has all the federated tables that I need to make the transfer between servers, but I found I can´t make a backup with mysqldump as it only saves database definition but not tables.
I only want to backup table definitions, not any data.


Any ideas?

Cheers,
Jorge

PD:Some configuration info :

MySQL Server:
version 5.0.15-max-log
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (October 17, 2005)
version_comment MySQL Community Edition - Experimental (GPL)
version_compile_machine i686
version_compile_os pc-linux-gnu
have_federated_engine YES

MySLQDump:
mysqldump Ver 10.10 Distrib 5.0.15, for pc-linux-gnu (i686)



Edited 1 time(s). Last edit at 11/03/2005 06:19AM by jvidalcastilla.