Disclaimer: I am new to WordPress.

When I add categories to my blogging site, where/how are these categories stored? If I want to change the names of these categories in batch, without having to go through the point-and-click UI, how would I go about it? Would this be done through a command-line interface?

  • 1
    check prefix_terms and prefix_termmeta table in your database – nonsensecreativity Feb 26 '16 at 17:52

There is extensive documentation on the database structure of WordPress in the Codex. Its pretty simple but still you probably do not want to mess with the data directly.

As you mentioned CLI I'd recommend WP-CLI which offers some commands you need. A quick example from the docs to change the name of the term with the ID 15 from the taxonomy category to `Apple:

wp term update category 15 --name=Apple
  • So, I shouldn't go into the database. Is management from the command-line an accepted methodology? Thank you. – Sabuncu Feb 26 '16 at 16:45
  • 3
    Yes. WP-CLI is the new hotness – jgraup Feb 26 '16 at 17:06
  • @jgraup Thanks so much. Another question recommends using it through Composer on Windows. – Sabuncu Feb 26 '16 at 18:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.