As reported  I have big problems with huge vocabularies in Drupal 7. Now I want to empty the big vocabularies, but I can't do that via the admin interface, because its running out of memory, so it can't be loaded any more.   How can I delete all terms of a vocabulary form the command line using drush and MySQL?  I know, I could do something like that:  DELETE FROM `database`.`taxonomy_term_data` WHERE  `taxonomy_term_data`.`vid` = 17   But what else would I have to delete?
124135
I have a large vocabulary, and  does not yet work for taxonomy.  does not do this as well. Are there other options for bulk-deleting taxonomy terms?
115371
Is it possible to build a single mysql query (without variables) to remove all records from the table, except latest N (sorted by id desc)?  Something like this, only it doesn't work :)  delete from table order by id ASC limit ((select count(*) from table ) - N)   Thanks.
109257
I realise this might be quite a simple question, but I'm still quite new to the command line and only have a grasp of basic commands.  I've downloaded some lecture presentations (~25 or so) from my University however on doing so they've been named things like...  L2%20Development%20of%20immune%20system.pptx L4%20Molecular%20Recognition.pdf   As you can see they've downloaded with the URL encoding %20 instead of a space.  My question is how to batch rename all of these files so that the %20 is removed and replaced with a space instead?
104961
So, I tried to run this query    which has many views (so I assume it's popular), but I get a message saying:     The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.   Now, true, that's not a trivial query, but is it really that bad? There isn't even a Join or anything.
48958
I have been trying to create a file called ~/dictwords.txt, which contains the number of words found in the file /usr/share/dict/words.  I already created the file then I removed it because I did it wrong I originally did the echo command. Then I tried this command and was so excited because I thought I was correct.  wc -w /usr/share/dict/words &gt; ~/dictwords.txt   It's still wrong, I am supposed to have just the number, without a file name.
63029
I have a folder with 137795 files in it.  I need to delete all of them.  When I run rm * I get -bash: /bin/rm: Argument list too long.  How do I get past this error?
75464
I have a directory on my Windows 7 machine that has hundreds if not thousands of sub-directories.  Some of them have files, some do not.  I want to delete all the empty directories.  Looking at the del and rmdir DOS command, it does not look like you can recursively do this without deleting all the files.  Is there a way to do this from the command line?
92991
I need to move some terms from one vocabulary to another by retaining all their data: translations, aliases, and node references.  Is it acceptable to change its vid column value directly in the database? The terms don't have hierarchy relationships which needs to be handled.
107749
In vim I can delete all lines that contain the word "price" with this  :g /price/d   How can I delete all lines that do NOT contain the word "price"?
34680
On one of my sites, I have over 600 Profile 2 profile types (most of them have between 20-30 field instances, some have additional fields just used in that one type). I've tested a few different methods for bulk deletion, but can't find a way using the Entity/Profile APIs to get the deletion to occur without basically wiping out the site for a few hours.  It seems that, when a content type, profile type, etc. is deleted, a ton of caches are cleared and rebuilt for each deletion, meaning the process goes something like:   Delete the entity type. (I do this part.) All the attached field instances are deleted. All the attached fields that have no other instances are deleted. All the field info and entity caches are cleared. All the caches are rebuilt (due to other visitors on the site trying to load pages which need those caches). Ready to delete another entity type.   Is there any quicker way of mass-deleting entity types (I've already removed all the entities themselves—they're quite simple and fast to remove)? I'd like to cut out steps 4 and 5, which take about 90 seconds.  (I changed to a different system for storing profiles, because the cache rebuild and memory requirements were getting out of hand with over 500 profile types (in addition to 20 other content types), and over 10,000 field instances!)
1552
We have an issue with a folder becoming unwieldy with hundreds of thousands of tiny files.  There are so many files that performing rm -rf returns an error and instead what we need to do is something like:  find /path/to/folder -name "filenamestart*" -type f -exec rm -f {} \;  This works but is very slow and constantly fails from running out of memory.  Is there a better way to do this? Ideally I would like to remove the entire directory without caring about the contents inside it.
16295
I would like to know how to clear recent created file names that appearing in the dialogue box when creating a new file:  I tried a lot without success
44861
The title says it all. At the moment in my custom taxonomies I'm getting the terms using the term id and taxonomy name.  Thought this question would've been asked before but can't find it anywhere! So just thought I'd ask and see if anyone has any answers.
36761
I am using Linux. And within an uncontrolled event, my 4GB system disk is full.  When I try to uninstall some program by sudo apt-get purge program-name, it gives me this error:  /usr/bin/mandb: can't write to /var/cache/man/25843: No space left on device   Is there any system file that can be deleted in this situation?
101978
What is best module to hide or disable or un-publish some terms in taxonomy or vocabulary like the way in the node tab of publishing in the back end
29856
This is my current command: execute as @a[distance=..100] run execute at @s if block ~ ~-1 ~ minecraft:quartz_block run /clear @s &lt;...&gt; I would like to clear the executing entity's inventory of all items without the NBT tag {PitAllow:1b}. I am in version 1.15.2 and if any plugins are required (Bukkit or Spigot) I'd be fine with installing those.
35185
So, I've looked at history and at Ctrl+R, but they are not what I thought I knew. Is there a way that I can type in the beginning of a command, and cycle through the matches in my history with some bash shortcut?  # mysq(some shortcut key)   Gives me:  # mysqldump  --add-drop-table -e -q -n -C -u  (some shortcut key) #  mysql -u ben.dauphinee -p