maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #02623
Re: mysqldump Spider tables
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@xxxxxxxxxxxx>:
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
>
Follow ups
References