On Sep 16, 2013 7:06 PM, "Platonides" <platoni...@gmail.com> wrote: > labs db server do contain the non-public data. It's just not viewable. So there aren't bin logs for just the non-public data. > You *could* make a dump of the database (probably creating a new tool, as mysqldump would simply dump the view definition)... assuming you that in doing that you don't kill labs filesystem. ;)
I think maybe percona-toolkit has relevant tools to sync between 2 versions of the same table (e.g. update a snapshot from yesterday from a current copy) but that probably relies on having primary keys on the tables and not all of our tables have primary keys. (I think external links was the one I was looking at recently which had no primary key) -Jeremy
_______________________________________________ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette