How do I delete all the user's posts, using drush? I frequently need to delete all comments/posts of a particular abusive user. It takes a hell of time to accomplish this with a browser. It would be great if someone could tell me how to do it using drush.
You could run something like this via drush php-script:

&lt;?php
global $user;
$user = user_load(1);
$result = db_query("SELECT nid FROM {node} n INNER JOIN {users} u ON n.uid = u.uid WHERE u.name = '%s'", 'alice');
while ($row = db_fetch_object($result)) {
  node_delete($row-&gt;nid);
}
?&gt;


There's also http://drupal.org/project/user_delete.