Migrate old admin's posts to his new user I'm taking over maintenance of a Drupal site but the old admin is staying on as a user.

I need to adjust the ownership of the posts currently under uid 1.

Is this query sufficient or is uid associated with a blog post in other ways?

Is there an admin module for this process?

UPDATE `drupal_node_revisions` r,
`drupal_node` n
SET n.uid = 13392, r.uid = 13392
WHERE 
r.uid = 1
AND n.uid = 1
AND n.type = 'blog'
AND r.nid = n.nid
Node data is stored in node table also.. It's a bad practice to change node content directly using sql queries...

You can use Views Bulk Operations (VBO) module to change node authors in bulk...


  This module augments Views by allowing bulk operations to be executed
  on the displayed rows. It does so by showing a checkbox in front of
  each node, and adding a select box containing operations that can be
  applied. Drupal Core or Rules actions can be used.