On Sep 16, 2013 7:06 PM, "Platonides" <[email protected]> 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
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
