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