[ECODP-dev] Script for dumping the live database

[Bert Van Nuffelen]

Hi John,

have a look to the scripts I send you. They are based on Ian Murray's
information last autumn. If you extend that one with an option to exclude
the user info that would great.

kind regards,

Bert


2013/2/25 John Glover <john.glover at okfn.org>

> 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
>>
>>
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130225/026edc84/attachment.html>