It is not simple, nor hard task. You need to know:
===1) For migrating entries ===
It is not enough to export
wp_post_meta tables. Posts are linked to categories (wp_terms, wp_term_taxonomy and wp_term_relationship tables..). So, at least (if it is pure Wordpress install, without any extra plugins and functionalities), to migrate those 5 tables. (for pages, it is somehow simpler - only wp_posts is enough, using post_type=>pages.)
===2) For migrating attachments ===
If you want to migrate pictures/attachments too, then you have to copy contents from
/wp-content/uploads to target site (be careful not to overwrite some files in target site, in case there already exists same name files).
===3) database correction ! ===
you should replace paths and strings ACCURATELY:
a) for example, if old path is '/home/user385247/public_html` , you should replace that with Target site's path.
b) you should replace
You'd better to use tools like this: https://itask.software/tools/wordpress-migrator
=== Summary ===
Wordpress built-in option is good for automatization, but (in case it matters to you):
- Bad side: It doesnt keep the same ID's of posts from old site.
- Good side: It automatically tries to import images too. (however, dont know it if do 100% accurately in some cases.. However, try it).
p.s. You can also search for 3rd party plugins to do this PARTIAL migration (if any exists).
NOTE, ALWAYS MAKE BACKUP before doing such things.