The simplest way would be to export your old site’s posts from phpmyadmin, manually edit the .sql file that you download and then upload the new file to your site’s database from phpmyadmin again!
Related Posts:
- When is the ‘post_content_filtered’ column in database cleared by WordPress?
- Can posts have parents?
- Where is the old post permalink slug stored?
- Separate Database Tables For Different Post Types
- How can I safely increase the character limit for post passwords?
- How to Group Posts by the First Letter or Number?
- Restore contents of deleted user
- How are terms connected with posts in database?
- Moving WordPress to new server: no posts found
- Custom Taxonomies Incorrectly Counting Revisions?
- database columns: post_title vs post_name
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Exporting Data from WordPress into a flat table
- Insert posts in two tables
- Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
- Importing New Posts from Live Site into Local Dev Site
- Manually removing revision post types
- How much of my site can I recover from public_html?
- Reset/Reorder posts ID in the MySQL wp_posts table
- How to store an extra (surrogate) ID when creating a post with wp_insert_post?
- How do I find which articles are missing a featured image in The WordPress database?
- Split WP_POST table based on post types
- Most recent post from another database
- What structure should post_content have in the database?
- Multiples Empty Posts were created and cannot delete them
- How to delete all the content of a wordpress site without deleting the Post and pages?
- Extracting post categories
- How to modify post content?
- After database migration, posts not showing up in dashboard
- minimum requirement to add posts via database
- How to bulk add vast amounts of posts
- Transferring WordPress Database – Serialised data
- Emojis replaced by ‘?’ automatically
- WordPress Local And Live Site
- Can’t update old posts 3.5.2
- Copy post to separate database with “add_action(….)”
- When open add new post or page WordPress add post with ID=0 continuously [closed]
- wp_posts table: safely remove unused columns to save database storage
- Anyone know why wordpress converts some html entities to their numeric equivalents?
- Remove a shortcode from all WordPress posts
- What do these phpMyAdmin errors mean on my WordPress databaes?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- why there are so many posts whoes post_type is revision? will these records waste too much database space?
- Delete all drafts?
- Is it possible to use WP_Query to only pull posts with attachments?
- Get posts and include taxonomy term
- Why my wp_posts data is so huge?
- Add field to user meta table in database when link is clicked
- Importing posts only – consequences?
- How safe is it to delete old posts edits to save database space?
- Delete post revisions only for a single post
- Move posts from a non-wordpress site to wordpress
- wp_posts table extremely large
- How to Assign / Move all Deleted post to a category
- Display post number by category
- Saving Post Data in Another Database
- Restore woocommerce orders
- How to select particular month post from table and update the post status using MySQL?
- Update field in database for users
- why the posts queried from sql is more than those showed on the page?
- Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
- Is there a function to get post info for any publish_status by post ID?
- Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
- How Can I Always Display A Particular Post First Using WP_Query?
- Help on conditional statement to accompany wp_insert_post function please?
- How can I globally italicize list of texts in the UI database or Posts? [closed]
- Menu Items disappearing/being empty on save or post edit
- My website is showing today’s date instead of published date since db migration to a new wordpress
- How to setup default value of post_id
- Prevent a post with a specific ID from being created
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Reusing old post IDs
- Trigger on DB make problem on wordpress?
- Comments are in database, don’t show up in WordPress backend or frontend
- Is there a way to save different data when USER interacts with the same POST?
- How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
- More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
- how i show manual data in a post
- Clean up customize_changeset in DB
- How do I get a certain set of posts from the database?
- Maximum number of posts per page before affecting performance?
- SQL trigger failes with post_content
- Surrogate ID for posts, is there an alternative field in the posts table?
- get backup file from wordpress database in x days
- Expired Post with More Recent Time Stamp?
- Converting Posts to Pages
- I moved my site to another server, wp admin works so does the front page, but posts don’t work
- How to change the publishing date of each posts?
- Can’t seem to replicate permalink structure for localhost development site
- Extra field in wp_post instead of postmeta
- Voting System, database connections?
- When I click edit on a post, all the content disappear. Does anyone know how to fix this?
- Given two custom post types: Automatically add meta fields from one custom post type to another
- Load posts from external source if not found in database
- Is there a maximum amount of pages for a multi-page post?
- How to make category for word post_content
- What effect can a large wp_post table have on overall site performance?
- How can I merge a several related posts into one post?
- Restore posts, but only posts that exist in my database backup
- Change permalinks in posts via SQL