How Many Data Tables Does WordPress Use?

Photo by dan

Someone just emailed a very valid question. It seems they were wanting to trim back their WordPress database to only the virgin install state and wanted to make sure they backed up only the data tables they needed to accomplish this. There could be arguments that not all of the virgin install data tables need to be restored but the question, verbatim, was, “how many data tables does WordPress use when you first install it?”

The answer is 11.

Of course just that answer isn’t worth much if you have 27 tables in your database. So here is the list of the tables WordPress creates when it is installed on your webserver:

  • wp_commentmeta
  • wp_comments
  • wp_links
  • wp_options
  • wp_postmeta
  • wp_posts
  • wp_terms
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_usermeta
  • wp_users

Need help? Has your WordPress been hacked or just become too cluttered to deal with? Contact me for WordPress support


Social Stuff


Digital Mechanic at The Ken Cook
I love small businesses and solopreneurs. There truly is no job too small for me because I believe everyone deserves great service and access. Hire me and I'll prove it to you!
Social Stuff

Leave a Comment

What is 7 + 15 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)