I don’t see any reason for this not to work. I have done similar transfers few times, and if you transfer all data correctly, and if posts in the wp_posts are well formed, with all data present (status, type…), it will work.
The tricky part might be the data that can’t fit into wp_posts, and it should go into wp_postmeta, you need to take care of proper post ids. Also, make sure to use correct format for date field, make sure to have both post_date and post_date_gmt filled, guid (some unique string for each post, WP uses URL by default), and make sure author ID’s are correct.
Related Posts:
- phpMyAdmin – Error > Incorrect format parameter?
- 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?
- Why is my database import losing text widget data?
- Why WordPress choose data serialization over json_encode?
- Are There Any Plans for WordPress to Support Databases Other Than MySQL?
- Reset Post IDs to less than 64bit integer
- Insert data in database using form
- how can get database name in wordpress?
- Does WordPress use the InnoDB engine for MySQL by default?
- $wpdb->prepare() warning in WordPress 3.5
- Best way to import users, post and categories from an external database
- Performance tips for a large user base [closed]
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- Long option names fail silently?
- wp_options is GB in size
- Can’t update database after wordpress update from 3.8.1 to 4.4.1
- Upload files – total size limit – WordPress/Contact Form 7
- Relationship between performance and database size
- Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
- WordPress and automated MySQL backups to a different host
- Scheduling posts in database
- Size article thumbnails and retrieve them directly from database
- Should I be able to run two different “close” code versions of wordpress with the same DB
- how to store arrays into a database
- How can I create a Bible search engine via WordPress? [closed]
- Error establishing a database connection; After importing DB & Theme
- Is it a bad idea to write audit/access/transaction log information directly to the filesystem?
- Export / import WordPress database
- WordPress choose wrong database
- Sync user meta data to a second database
- Is it safe to delete unnecessary user metadata?
- Improve performance by removing unnecessary database queries
- WordPress Relational Database
- WordPress Database Huge wp_usermeta Table
- wp-cli search is returning ‘search’ is not a registered subcommand of ‘db’
- Switching Databases in LocalHost
- cache specific data?
- wp_insert_post causing There was an error connecting to the database: Access denied for user ‘root’@’localhost’ (using password: NO)
- How to update the values when the featured image has changed?
- Does WordPress $wpdb functions wait when table is locked?
- Unable to set a default serialized array using dbdelta()
- Importing 10 Years of Media into the WP Database
- I have a 1300 line excel spreadsheet that needs to get into a wordpress site ASAP – Looking for ideas
- 2 WordPress sites with 2 databases but sharing the same users
- Insert Query not working in the form
- Enter user registration information in the database
- connecting to DB from custom php file
- Make changes of wp-db.php file persistent against updates
- Importer fails to import every post
- Change the default data installed when setting up WordPress
- Clear Terms from Taxonomy for Specific Post IDs?
- Unkown meta_value in ACF
- Buddypress avatar image in database [closed]
- WordPress security [closed]
- How to split the WordPress database?
- $wpdb->get_var – What value is returned when zero records are found?
- WordPress SQL – How to Check for Category?
- SymmetricDS in dev + prod workflow?
- Fixing YARPP plugin FULLTEXT MySQL indexing
- Getting WordPress to work inside a rails 3 application
- Advantages of dbDelta
- Only allow user to access a link once a year, based on their joining date
- Error establishing a database connection in wordpress site , website not opening
- Counting post and changing roles in mysql database. Query not code
- 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’
- Help with $wpdb on custom code
- “BS_” rows in postmeta table
- Migrating meta_key and meta_value from old theme to new one
- How do you enable scripts on a WordPress installation in Softaculous?
- How to rerieve comments and their replies from DB
- Inserting data with Geometry field
- I Want a More Concice Form of Data than an Array
- Export only a part of the database for migration
- Why am I being prompted to reinstall wordpress?
- Duplicate database to roll back theme & content changes
- database error WordPress move from one hosting to other
- Select data from foreach loop and send it to wordpress database
- mySQL database size large, but tables size less
- Error establishing database connection error during first WordPress run
- Same DB for live and dev versions
- update multiple user meta field based on another meta field
- After renaming MySQL database, I can no longer access my Blog page
- execute custom function on database connection error
- Call to a member function insert()
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- version control for wordpress? (wordpress folder and database at same time)
- not saving post in wp_post wordpress database table
- How to add data from wordpress tables to new database tables you have created
- Install WordPress with SQL database
- How to back-up a database on IIS
- Creating Job Tickets
- Best db table structure for users with many records
- Where are database files of a WordPress website?
- SQL query to rewrite all media URLs to end with .webp
- Weird WP -Cli Error Connection Refused
- Many images in wp-content/uploads folder that are not in Media Library