WordPress stores the content of pages in a MySQL database. When you create a page in WordPress, it doesn’t exist as a single file you can find on your server.
Instead, various elements of the page, including its text content, author, and publication date, are stored in different tables within the MySQL database.
The main tables that WordPress uses to store page content are:
- wp_posts: This table stores the main content of your pages, such as the title, content, date, and type (e.g., post, page).
- wp_postmeta: This table includes meta-information related to pages, like custom fields.
To visualize or interact with these pages on your website, WordPress dynamically generates the HTML content by querying this database based on your requests (e.g., when someone visits your page) and then applies your site’s theme to display the page.
