Where are WordPress Pages Stored & How to Find Them

Where are WordPress Pages Stored & How to Find Them • WPShout

It’s a very reasonable question: where are WordPress pages stored? There are a lot of ways to answer it though. Without getting too pedantic, we really need to understand a few different levels of the questions to really give a good answer. In this Quick Guide we’ll cover a few different of the answers you may be seeking.

Quick Ways to Find WordPress Pages

I think there are two quick answers you might come to this tutorial for, so I’ll briefly summarize them for people in a hurry.

  • WordPress Pages are stored by the CMS (content-management system). So the quick way to find and modify them is to go into the “backend” of your WordPress site and look in the left-side menu for “Pages.” There you’ll find them.
  • WordPress (Posts and) Pages are stored in the MySQL (compatible) database that WordPress relies on. Within that, even “Pages” (or other WordPress “custom post types”) are stored in the wp_posts table of the database. You’ll typically access these with a tool like phpMyAdmin.

Where WordPress Pages are Located, The Video

In this video I cover in a bit more detail the two answers above. If you’re a visual learner, enjoy!

More about WordPress Databases and Where to Find Pages There

To understand where WordPress stores pages (deeper than the “in the admin area” level) you need to understand that WordPress uses a thing called a “database.” Databases are common in lots of web applications, because they are much faster as a way to store (and retrieve) complex and structured data. Filesystems are great for storing and retrieving large files, but they’re less good at “show me the posts written by Susan in June of 2020.” Databases are great for that type of stuff!

So WordPress relies on a “MySQL” database to store most everything about your site but images and other media files. (While great for small data, databases aren’t really good at storing large files.) Typically, you’ll have nine database tables from WordPress, and most people will name them like wp_options, wp_posts, wp_users, etc. (Strictly speaking, WordPress allows you to set a “database prefix,” so it’s happy to look for the same data in wp234_posts or randomwords_posts.)

Another thing to know about WordPress: under the hood all “post types”—Posts and Page that WordPress always have, and also “Reviews”, “Portfolio Items” etc that you might have added—are the same. To WordPress, for historical reasons, they’re all “posts” in a way. The most important way you’ll see that, they’re ALL stored in the wp_posts table.

How to Access the Database with phpMyAdmin

To see, modify, etc the WordPress database, most webhosts provide a tool called “phpMyAdmin.” Like WordPress, this a “free” and open source tool, which is why

[…]

 



This article was written by David Hayes and originally published on WPShout.

Disclosure: Some of the links in this post are "affiliate links." This means if you click on the link and purchase the product, We may receive an affiliate commission.

Leave a Comment

You have to agree to the comment policy.

Scroll to Top