Le 20 mai 2015 à 19:13, Guillaume Lefranc <guillaume@adishatz.net> a écrit :

Hello Nicolas,

Stephane has opened a task for this: https://mariadb.atlassian.net/browse/MDEV-8183

It's being reviewed and may be added in future releases.

Thanks for your feature request.

Regards,

Guillaume

2015-05-18 16:35 GMT+02:00 Nicolas Payart <launchpad@htmledit.com>:

Hi list,

I am using Spider Storage Engine for multiple purpose.
I often create spider tables as a drop-in replacement for Federated(x) tables.

But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables.

I expected these two close storage engines to behave similarly...

Is this an expected behaviour of Spider SE (and/or mysqldump)?
Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table?

Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database.

Thanks,
--
Nicolas


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp