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
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Why WordPress choose data serialization over json_encode?
- Reset Post IDs to less than 64bit integer
- Does WordPress use the InnoDB engine for MySQL by default?
- Performance tips for a large user base [closed]
- Moving an entire wordpress site from one domain to a new domain and database
- Custom DB_COLLATE (collation) value not working on fresh install?
- Suggestions for WPMU Migration (advanced)
- What causes the “max_user_connections” warning on WordPress frontend?
- $wpdb->update has finished saving trigger?
- How to change database values on theme update
- Unable to set a default serialized array using dbdelta()
- Change the default data installed when setting up WordPress
- $wpdb->get_var – What value is returned when zero records are found?
- SymmetricDS in dev + prod workflow?
- Fixing YARPP plugin FULLTEXT MySQL indexing
- wpdb Insert unknown post data dynamic foreach loop
- How do I use a database in a custom theme?
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- How to rerieve comments and their replies from DB
- Inserting data with Geometry field
- Export only a part of the database for migration
- database error WordPress move from one hosting to other
- update multiple user meta field based on another meta field
- not saving post in wp_post wordpress database table
- How to back-up a database on IIS
- Where are database files of a WordPress website?