I never personally tried this, but your images and posts reside in your {prefix}posts (wp_posts) table. I would also copy {prefix}postmeta (wp_postmeta) over.
So copying over those table should do what you want.
Keep in mind that this won’t copy your categories and tags (meta), and your comments (comments) they reside in other tables, you could find those easily they have meta and comments in their names. Copy those too if you want that.
Related Posts:
- WordPress Unit Testing – Cannot Create Tables
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- stdObject stored in database. How does one convert it to usable format?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- WordPress mysql table double prefixes
- Change WordPress prefix for only one table?
- input data and output table [closed]
- Retrieve data from the database to table such as comments in the admin control panel
- Change options table prefix only
- Query multiple tables at once?
- Why does changing Database Table Prefixes result in loss of content?
- Can I customised default WP table
- Should I use an additional column in the DB?
- Will adding & modifying default WordPress table index break future WordPress update
- What is wrong here? Issue with post_id and meta_value
- How to edit custom table data in frontend
- How to map data on CSV to web pages?
- Create hundreds of users with just ID in phpMyAdmin
- Have WordPress Use a Different Database for users
- What is the difference between an ORM and an ODM?
- Checking if Database Table exists
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Is it possible to define two databases for one installation?
- Syncing local content with development / staging sites
- Export WP database for import using WP-CLI on Vagrant Box
- How To Make Connection To WordPress Data Base In A Plugin?
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- “MySQL server has gone away” since update to 3.8
- WordPress page title repeated in SOME pages
- Why is $wpdb->get_results failing on certain tables but not others (which have data)?
- Should I global $wpdb outside of any of my plugin’s functions scope?
- How to correctly add a table to the WordPress MySQL database
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- Merge two databases: OLD SITE -> NEW SITE
- Is it safe to convert tables from MyISAM to InnoDB?
- Use one WordPress database with multiple instances of one site
- Who is responsible for data sanitization in WordPress development?
- How do I properly update the WordPress database password?
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- $wpdb->insert is not working
- WordPress Install and Database on separate hosting?
- Moving a site from a temporary domain to the live domain [duplicate]
- Moving WP from local server to live, error establishing a db connection
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Exporting table to csv works in the admin but exports HTML data when used on the front end
- wp search-replace (not executing)
- Create table from array with prepare
- Migrate database between 2 different wordpress version
- SSO system between 2 WordPress installs on different servers
- Form that sends data to an admin panel and can export it
- is $wpdb->get_results() safe enough
- dbDelta not installing database
- Convert user passwords to MD5?
- is wordpress stores Role Id in WP database?
- Why do database examples sometimes finish with an add_option call?
- Does post_meta data need to be unserialzed?
- Can’t update WordFence Options, clear data manually
- How to backup my site and restore my wordpress site
- Is it possible to have more than 1 MySQL database in my WordPress blog?
- How to fetch records from database WordPress
- AJAX wp-mysql running too slow
- Delete/Replace words from X to Y in post content
- How get Data form wordpress database as array not stdclass?
- cannot connect database
- Multiple WordPress sites installs sharing the same database but with different content and domains
- Brandoo WordPress Unable to Update to WordPress 4.2.2
- Connecting to wordpress database in my application [closed]
- Remote database -> massive response time increase?
- Custom Post Type not showing anything added by code anymore?
- How do I have a user upload a blog post and then retrieve that to display in a card on the site?
- Delete user with only subscriber role
- WordPress keeps redirecting to localhost
- get value from ‘terms’ table
- How to rename custom table name programatically in wordpress?
- pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
- generate PDF from member information
- mysqli_query(): MySQL server has gone away for Curl Request
- Help posting values to DB on submit using $wpdb->query
- WP website showing blank page after moving from subdomain to main domain
- create a table using user meta custom data
- wpdb query to insert images in to post/page gallery
- Creating a database in my plugin not working
- How to create index (sql) to a meta_key?
- WPCLI search and replace in a particlar site dir effect another site-dir
- get_user_meta and umeta_id
- $wpdb not working
- Send data to database after redirect (and popping out of iframe)
- Simple email input store in database
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- What is best for saving lot of extra detail of user?
- Insert Extra fields added in the front end registration form to DB
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Upload wordpress from localhost to 000webhost