[Clipart] [Cctools-cchost] SVN changed and updated

Mike Linksvayer ml at creativecommons.org
Tue Mar 3 10:27:25 PST 2009

This has very likely changed in the last ~16 months, but this was a
draft of an extract created for
... I think the version actually used was pruned further.

create table cc_tbl_user_publiconly select user_id, user_name,
user_image, user_description, user_homepage, user_registered,
user_favorites, user_whatilike, user_whatido, user_lookinfor,
user_num_remixes, user_num_remixed, user_num_uploads, user_score,
user_num_scores, user_rank, user_num_reviews, user_num_reviewed,
user_num_posts, user_language, user_quota from cc_tbl_user;

./mysqldump -u mixter --password=XXXXXX
--ignore-table=mixter.cc_tbl_user --ignore-table=mixter.mixter_survey
mixter > ~/ccmixter-publiconly-20080102.sql

I think Victor is offline right now, but here's a copy of his standard
rant about taking too much from this data:

"There are many community specific aspects to the choices made by our
users that can not be drawn from the data simply because the text in
the tables can only go so far in describing what the users are
actually reacting to when making decisions about what samples to
re-use. For example you may determine that uploads tagged
acappella+female_vocals+meloday get remixed more than
acappella+male_vocals+spoken_word but you'll never be able to detect
is that women who "belt" the vocals will almost never get remixed even
if they are exactly on pitch and in sync. Whereas a breathy "sexy"
vocal will get dozens or hundreds of remixes even if out of tune and
hard to sync to a back beat. That's just one example (one that hits
you over the head once you actually listen to the tracks) but there
are many other factors (social: celebrity, friendships, aural: no
reverb vs. lots of reverb, etc.)"

On Tue, Mar 3, 2009 at 12:31 AM, Jon Phillips <jon at rejon.org> wrote:
> I'm concerned about how to get a db copy that has privacy info
> scrubbed. I'm a bit paranoid about this. Does anyone know how
> Wikipedia handles this?
> For now, please setup local instance and test out with SVG
> files...need to think this through with the new setup.
> We have both the live site, and a test site, for staging changes, etc.
> I can generate both a config dump of all configurations from the
> current site, but even that contains some insecure passwords I
> believe. Then, need a cleaned db dump, hmmm
> I'm cc'ing ccHost mailing list about these things. Victor, have you
> solved this issue to get scrubbed mysql table and configs. Didn't you
> provide something like this for some reseachers for ccMixter?
> cheers
> jon
> On Mon, Mar 2, 2009 at 7:45 AM, Jochen Staerk <jstaerk at usegroup.de> wrote:
>> Hash: SHA1
>> Hi
>>> http://openclipart.org/wiki/SVN
>> thanks, that's great!
>> I tried the developers root but i couldn't find a database dump, do you
>> think you could add one there? It doesn't need to be always up to date
>> but I would really like to get a test system, i.e. with the (svg,
>> png)files and database  of the current production system.
>> Background: e.g. the API problem could be related to a single file
>>> that we have control over adding developers to SVN, and our new
>>> virtual machines which we have more control over.
>> silly question, you can't just let me rsync your .vmdk, can you?
>> - --
>> mit freundlichen Grüßen
>> Jochen Stärk
>> www.usegroup.de            (home office)
>> Albigerstr. 22             Am Wald 3
>> 55232 Alzey                55270 Ober-Olm
>> Tel: (06731)997997-5       (06131)584278-0
>> Fax: (06731)997997-6       (06131)584278-1
>> Mobil: (0177)4512645
>> Version: GnuPG v1.4.9 (GNU/Linux)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>> iEYEARECAAYFAkmr/ysACgkQIQmdcXOPL7y8xwCfdDmi7e3T/MYEYKmOh9uDRnJ4
>> ElQAnRoDWlVYeq3o7kOGSarmCM/kwLJV
>> =ebNR
>> -----END PGP SIGNATURE-----
> --
> Jon Phillips
> http://rejon.org/
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> Cctools-cchost mailing list
> Cctools-cchost at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/cctools-cchost

 http://support.creativecommons.org help us
 build http://creativecommons.org/asharedculture

More information about the clipart mailing list