← Back to team overview

maria-discuss team mailing list archive

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