How to fully import records into WordPress database?

Question

SQL

How to fully import records into the WordPress database completely?
There is a database on WordPress in which there are only pages, but there are no records.
How to import only records into this database.
The standard import plugin is unfinished. It doesn't attach pictures.
Is it possible to somehow download the necessary tables in phpmyadmin, and then make an SQL import query?

Answer 1

To import posts, pages, etc. use the Wp All Import plugin. Export to xlsx first || csv, and then import through the plugin.
Another option, if you only have a database, but no website, then as an option you can connect the database to some self-written script, then extract records from it. then using the Wordpress REST API to import to the production site.