[ECODP-dev] Script for dumping the live database

[John Glover]

Hi Bert,

The script is only 3 lines so I'm not sure how much documentation should be
necessary. It needs to be able to access the CKAN database with whatever
user can read the data on whatever machine the PO has the database running
on. I can add variables to the top to specify these.

The only information taken from the user table is the id, name and creation
date (which could be useful in debugging). Do we need to restrict this
further?

Thanks,
John


On 25 February 2013 10:19, Bert Van Nuffelen <bert.van.nuffelen at tenforce.com
> wrote:

> Hi Darwin,
>
> A what late comment on this script: This script will not be accepted by
> PO. The obvious are which user; which machine; no docs....
> Can you extend this script(s) with an option to deal with anonymizing the
> users? This are the backup scripts we have already submitted to PO and
> which satisfy already 70% of their concerns.
>
> kind regards,
>
> Bert
>
>
>
>
> 2013/2/13 Darwin Peltan <darwin.peltan at okfn.org>
>
>>  Hi Bert,
>>
>> Please see attached the script to dump the live database. Please can you
>> test it yourself on the 10F test server and then send it to the PO.
>>
>> It blocks out any sensitive data and produces 3 files that need to be
>> supplied back.
>>
>> Many thanks,
>>
>> Darwin
>>
>> Darwin Peltan
>> Project Manager
>>
>> The Open Knowledge Foundation
>> http://www.okfn.org
>>
>> Skype: darwinp
>> Twitter: @darwin
>>
>> _______________________________________________
>> Ecodp-dev mailing list
>> Ecodp-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>>
>>
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be
>
> Bert.Van.Nuffelen at tenforce.com
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130225/8ec4a28c/attachment.html>