I have a csv file with the following columns
Title | Content | Image | Category
I want to import this csv file to WordPress database. I know a csv file can be imported via phpmyadmin. But when i opened the table ‘wp_posts’ i couldn’t find any columns that says image or category.
Are those in another tables? If so how can i import it?
A PHPMyAdmin import isn’t recommended. Instead, import via a plugin such as WP All Import.
The reason being is that some data is stored as content in the wp_post table, and some (like category terms) are stored as metacontent in wp_postmeta, with another table describing the relationship.
An import plugin will handle this appropriately.
I’m using wp ultimate csv importer plugin to import & export posts, pages, custom posts and custom fields in to wordpress with the csv files. You can try that plugin and it is cool.
https://wordpress.org/plugins/wp-ultimate-csv-importer/