Is there a clean separation between the WP tables involved with
presentation vs content?
I would say “no”. There is no clean separation. There is mostly-separation. Most of your content is in the post and taxonomy tables, and most of your presentation is the options table. But you also have things like sticky post ID
s in the options table, which is borderline content vs presentation, and you have widget data, including the widget content where applicable, in the options table which is definitely content, or definitely in my opinion anyway.
There are other questionable cases as well, such as the blog description. It is in the options table but is it content or presentation? Hard to say. It is static across themes but seems like content to me. And that is not to get into to what various plugins might store in the various tables.
In short, I would not count on a clean content vs presentation demarcation in the tables. There is a lot of separation, but I would not call it “clean”.
Related Posts:
- Multiple developers / editors working on a site in progress
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Solution for database version control and deployment?
- How to migrate a HTTPS WordPress installation to localhost?
- How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
- Migrating data between local and development server
- Best way to import users, post and categories from an external database
- Syncing local content with development / staging sites
- Organizing WP Pages based on old website database
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Have multiple local wordpress installs share a wp-content folder and database
- Migrate a Non WordPress database to wordpress [closed]
- Why do wordpress store pages/posts within the database instead of files? [closed]
- Database sync between local and production
- Weird issue with database migration and SSL links
- How to fix unchanged URLs in Database after running serialized search and replace script?
- Migrating database / content of non-CMS site to WordPress
- How do I reset a self-hosted WordPress URL?
- I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
- Export all content from wordpress
- Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
- Moving minor updates between local and live sites – just database?
- Why do mass updates to post_content shows in front end, but not in edit screen?
- Output custom content not from the posts table?
- How to move the WordPress site Layout from test site to Production site?
- Merging two databases without borking it
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
- Setup private content for specific users with daily updates [closed]
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Copying database tables to new database
- Migrating from PDO using SQLite to clean new install using MySQL
- Migration: Copying database content to a different server
- Change WordPress URL in sql file via Terminal
- Strange characters added to the database
- Remove empty rows from the database
- After database migration, theme mods don’t show [closed]
- Problem migrating to localhost
- Can local WordPress installs share /wp-content/ folder and database?
- Delete/Replace words from X to Y in post content
- content disappearing minutes after it’s published
- WordPress url transformation script
- How to transfer from localHost to live but use the already existing database on the server?
- Backing up WordPress database and files
- Image link issues after importing a database backup to my local web server
- Database migration issues – Error #1046 No database selected
- echo site_url() returns a different value than what is in the database siteurl field
- My website is showing today’s date instead of published date since db migration to a new wordpress
- Migrate Users From laravel to wordpress
- /wp-admin not accessible after migrating to local host (no plugin issue)
- How to fix Uploaded to this post option to see group of images uploaded to a post?
- How do you enable scripts on a WordPress installation in Softaculous?
- WordPress site migration – locked out of admin area
- Malware in old website – how to migrate?
- WP website showing blank page after moving from subdomain to main domain
- WordPress Migration – Issue with admin panel changes
- Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
- How to edit posts/pages without making the change live?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- After Migration From dev, Only my Links to the Homepage Still Redirect to dev
- I cannot change anything in my wordpress database from within wordpress?
- Local Content different from Remote Content
- Media library images “missing” after migrating them using SQL
- Restoring .sql backup results in “Error establishing a database connection”
- import (migration) user database to wp-users
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Update references to pictures on website after moving to new URL
- Moving database from WP 2.6 to 3.5 problem
- Importing Concrete5 content to WordPress
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- Display custom data based on URL slug
- Database not loading after transfer via phpmyadmin
- What is an ORM, how does it work, and how should I use one? [closed]
- What is the difference between an ORM and an ODM?
- What is this JavaScript “require”?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- What is this JavaScript “require”?
- What is “Advanced” SQL?
- What’s the difference between identifying and non-identifying relationships?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- What are the differences between B trees and B+ trees?
- MySQL SELECT increment counter
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Example of a strong and weak entity types
- Oracle SQL query for Date format
- phpMyAdmin – Error > Incorrect format parameter?
- Strange Characters in database text: Ã, Ã, ¢, â‚ €,
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Database vs File system storage
- Can I have multiple primary keys in a single table?
- Exclude Statement in SQL
- How do you query for “is not null” in Mongo?
- What is a file based database?