Transfer articles to another user

**hollosch** · May 6, 2015

Hi,
how can i transfer articles from pegasus to hollosch on my site?
After import from mediawiki pegasus have lots of entries which i will transfer to me.

http://geislingen.net/members/?type=vw

**pegasus** · May 6, 2015

Code:

UPDATE vw_revision
SET userid = {hollosch_userid},
username = 'hollosch'
WHERE username = 'pegasus';

UPDATE vw_page
SET creatorid = {hollosch_userid},
creatorname = 'hollosch'
WHERE creatorname = 'pegasus';

UPDATE vw_redirect
SET userid = {hollosch_userid},
username = 'hollosch'
WHERE username = 'pegasus';

You can repeat for basically every table that has both 'userid' and 'username' fields, but these are the most important.

For the numbers on your member ranking page, it is not currently possible to re-count who did what. I'm working on a tool for that, but it's not ready yet.

**hollosch** · May 6, 2015

That have to wait until the actual db-problem is solved...

**hollosch** · May 25, 2015

Should i wait for the tool or start the db-changes?

**pegasus** · May 25, 2015

It doesn't really matter, but you would have to make the db-changes before using the tool anyway. The profile counts will still be wrong until the tool is ready.