maria-discuss team mailing list archive

[Nicolas Payart <launchpad@xxxxxxxxxxxx>]

I have read Stephane's PR and his proposal to add an option to mysqldump (--no-data-med) taking into account Spider tables.
This is exactly what I need!

Thank you,
Nicolas

> Le 20 mai 2015 à 19:13, Guillaume Lefranc <guillaume@xxxxxxxxxxxx> a écrit :
> 
> Hello Nicolas,
> 
> Stephane has opened a task for this: https://mariadb.atlassian.net/browse/MDEV-8183 <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 <mailto: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 <https://launchpad.net/~maria-discuss>
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/~maria-discuss>
> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
>