Podcast Episode

494 – Where is Data Stored in the WordPress Database?

Announcements

Is there a plugin for that?

With more than 50,000 plugins in the WordPress repository, it’s hard to find the perfect one. Each week, I will highlight an interesting plugin form the repository.

For more great plugins, download my 50 Most Useful Plugins eBook.

Hidden By Roles the Admin Bar will allow you to set which logged in users see the admin bar.

Where is Data Stored in the WordPress Database?

  • wp_commentmeta – meta data for each comment
  • wp_comments – comments
  • wp_options – all the options for WordPress (plus some WordPress plugins store info here
  • wp_postmeta – metadata for posts
  • wp_posts – posts, pages, menu items are found in this table
  • wp_terms – categories and tags are in this table
  • wp_termeta – metadata for the terms
  • wp_term_relationship – posts are associated with categories and tags from the wp_terms table
  • wp_term_taxonomy – describes the taxonomy (category, link, or tag)
  • wp_usermeta – metadata for each user
  • wp_users – the list of WordPress users

Is there a plugin for that?

With more than 50,000 plugins in the WordPress repository, it’s hard to find the perfect one. Each week, I will highlight an interesting plugin form the repository.

For more great plugins, download my 50 Most Useful Plugins eBook.