By rcross on

yes, we all make mistakes we want to correct. Mine is a simple error. When i started using drupal for my main site, i started posting blog entries (and pretty much everything else) with the main account (usid 1). I did actually create a different account with my name (usid 2) and I should've known better, but after reading the drupal best practices I want to correct my mistake. Is there a way for me to move all that content to a different account?

-Ryan

⋅ Categories: Drupal 4.6.x

Comments

hrbrmstr’s picture

hrbrmstr commented

It would be as simple as a SQL UPDATE statement if you had access to mysql...

$mysql yourdupaldatabasename

mysql>UPDATE node SET uid='2' WHERE uid='1';

NOTE: that will change *all* nodes with a uid of '1' to a uid of '2'. You may not want to do that to all node, so you can use multiple expressions in the "WHERE" part of the statement to be more selective.

You can install the Drupal DBA module to run the query as well (I believe).

sepeck’s picture

sepeck commented

I will note that UID1 here is Dries but Drupal.org pre-dates my write up. :) You need to balance the needs of your site and it's usage vs accounts and accidents. I would be less concerned about single user sites than multi-user sites mainly because UID1 has all the rights of a site. It's sort of why you don't run root on a *nix system or local admin on a windows box... just in case.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide