On Mon, 16 Jan 2017 14:55:05 +0100
Aurelien Bompard <abompard(a)fedoraproject.org> wrote:
Hey folks,
I have a big mailman update that I'd like to test on staging, and I
think that my testing would be more realisting if I had some
production data on the staging DB. I mostly need public data, I don't
need the user accounts or the private lists data for example.
I realize that I could dump the prod DB to a text file (excluding
private tables), transfer it to my workstation and re-upload it to
staging, but I'm talking gigabytes of data here, so I wonder if you
know of a better way, that would stay in the Fedora Infra (and
possibly in the same datacenter).
Make a staging sync playbook. ;)
Look at the ansible/playbooks/manual/staging-sync/koji.yml
it takes the prod db, syncs it over to staging and then runs some sql
on it to get it working for staging. ;)
So, basically you just need to do this for your db...
kevin