On Sep 16, 2013 7:06 PM, "Platonides" platonides@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