1,784
edits
Changes
Created page with '== Gitorious DB hacking == === Web interface === http://admin.osuosl.org/phpmyadmin === Get a MySQL prompt === type "db" at the prompt, than give the db password from ~gitoriou…'
== Gitorious DB hacking ==
=== Web interface ===
http://admin.osuosl.org/phpmyadmin
=== Get a MySQL prompt ===
type "db" at the prompt, than give the db password
from ~gitorious/config/database.yml
=== Change project owner ===
select * from users where login='sdz';
select id from projects where slug='soas';
update projects set user_id=117 where slug='soas';
=== Add committer ===
insert into committerships set
user_id=299,
repository_id=275,
kind=2,
created_at='2009-08-03 08:12:19',
created_at='2009-08-03 08:12:19';
=== WARNING ===
To zap a user account, make sure you also remove
its related records from all tables (committers,
projects, repositories, events...)
=== Web interface ===
http://admin.osuosl.org/phpmyadmin
=== Get a MySQL prompt ===
type "db" at the prompt, than give the db password
from ~gitorious/config/database.yml
=== Change project owner ===
select * from users where login='sdz';
select id from projects where slug='soas';
update projects set user_id=117 where slug='soas';
=== Add committer ===
insert into committerships set
user_id=299,
repository_id=275,
kind=2,
created_at='2009-08-03 08:12:19',
created_at='2009-08-03 08:12:19';
=== WARNING ===
To zap a user account, make sure you also remove
its related records from all tables (committers,
projects, repositories, events...)