I regularly import the Drupal database from our hourly backups into our local development server for testing purposes. That’s all well and good, but I really wanted a way to remove any genuine registered user data from the database so that I keep things nice and anonymous.
Drupal stores the user’s ID in the user_roles table if they have an extended role – i.e. anything above a simple registered user status. All of our team have extended roles, so it’s just a case of finding the users that don’t appear in the users_roles table. To do that you just need to execute the following script on the database you want to purge NOT YOUR PRODUCTION DATABSE.
[sql]
DELETE
FROM users
WHERE users.uid NOT IN (
SELECT users_roles.uid
FROM users_roles
);
[/sql]
REMEMBER: this query is going to delete users, only use with a copy of your database, never on a production server.
You can also use this to select any profile data or user generated content as well (I just overwrite with filler text). Which is nice.
my free cam…
Getting registered users from your Drupal database « SlashZero Limited…
computer working from home…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
Greetings…
hi I considered you possibly condone my guide…
Salutations…
I considered sending this pingback wonderful feature…
stream movie…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
low vitamin d symptoms…
Have you ever thought about including a little bit more than just your articles? I mean, what you say is valuable and everything. However think of if you added some great images or video clips to give your posts more, “pop”! Your content is excellent…
Say thank you for write about incredibly very good informations. Your net is great.I am impressed by the details that you’ve on this blog
top dating sites…
Through my observation, shopping for electronic devices online can for sure be expensive, although there are some guidelines that you can use to obtain the best products. There are always ways to obtain discount deals that could help to make one to ge …
popular dating sites…
Howdy! Someone in my Facebook group shared this website with us so I came to look it over. I’m definitely enjoying the information. I’m bookmarking and will be tweeting this to my followers! Great blog and outstanding design….
online dating tips…
hey there and thank you in your info ๏ฟฝ I๏ฟฝve certainly picked up something new from proper here. I did alternatively experience a few technical issues using this website, since I skilled to reload the website many occasions prior to I may just get i…
aukcije srbije…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
live sex intercourse…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
Feedcastz2…
Great blog post, saw on…
Writing style…
Hey, you used to write wonderful, but the last several posts have been kinda boring… I miss your super writings. Past few posts are just a bit out of track! come on!…
dating,chat,love,find love…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
Tumblr and Digg…
Tumblr and Digg just now linked to this super interesting place…
Tumblr…
Tumblr linked to this site…
Super post…
I really appreciate this post. I’ve been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thanks again!…
Tumblr…
Tumblr linked to this website…
sexycam…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
I just want to mention I am just beginner to blogging and honestly liked you’re web blog. More than likely I’m planning to bookmark your blog post . You definitely come with amazing article content. Thanks a bunch for sharing with us your blog.
athens escort…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
Tumblr linked to this website
free dating service…
Once I initially commented I clicked the -Notify me when new feedback are added- checkbox and now each time a remark is added I get 4 emails with the identical comment. Is there any approach you possibly can remove me from that service? Thanks!…
Really impressed! Everything is very, very clear, open is a description of the problem. It contains the information.
dating sites for free…
Aw, this was a very nice post. In idea I would like to put in writing like this additionally ๏ฟฝ taking time and precise effort to make an excellent article๏ฟฝ however what can I say๏ฟฝ I procrastinate alot and by no means appear to get something done….
learn to draw…
Getting registered users from your Drupal database « SlashZero Limited…
chat romanesc…
[...]Getting registered users from your Drupal database « SlashZero Limited[...]…
Just reading here…
It’s truly a nice and helpful piece of information. I am glad that you shared this helpful information with us. Please keep us up to date like this. Thank you for sharing….