A question for seasoned WP folks - we have one site running an older (5.7) version of WP. Some of the plugins on the site have died and refuse to be removed. So I need to create a clean, updated version of the site and install all plugins etc from scratch. (Meaning I can't just clone the site and update it).
I want to pull in things like posts, pages, media, users, comments, tags, categories etc. The native WP export/import won't work for me it just times out. I have looked at some plugins but none I have looked at allows you to exactly specify which items you want to export/import.
I am considering moving the files and tables manually, I am just concerned I will miss an important table, or that there may have been some table changes from the site WP version and the current WP version.
Does anyone have any recommendations for this situation? Maybe any plugin recommendations, or ideas of how best to achieve this?
Many thanks for reading.
A question for seasoned WP folks - we have one site running an older (5.7) version of WP. Some of the plugins on the site have died and refuse to be removed. So I need to create a clean, updated version of the site and install all plugins etc from scratch. (Meaning I can't just clone the site and update it).
I want to pull in things like posts, pages, media, users, comments, tags, categories etc. The native WP export/import won't work for me it just times out. I have looked at some plugins but none I have looked at allows you to exactly specify which items you want to export/import.
I am considering moving the files and tables manually, I am just concerned I will miss an important table, or that there may have been some table changes from the site WP version and the current WP version.
Does anyone have any recommendations for this situation? Maybe any plugin recommendations, or ideas of how best to achieve this?
Many thanks for reading.
If your goal is to install a newer version without plugins, you just need to generate a backup of the database and copy the uploads folder along with this database. Afterward, simply reinstall WordPress, import the MySQL database, and go into wp-content, copy the zipped uploads folder that came from the source site and extract it. You also need to install the same theme that you used in the previous version. If the site hasn't changed its URL (same domain), you don't need to change anything in the database. But if the domain or subdomain is different, you have to change the URLs via bash script, wp-cli command, or even with SQL command in phpMyAdmin if necessary. I use WordOps for all my sites and configure everything quickly via SSH and rsync, but I think installations with cPanel and others also work.
You have two options:
Use WP All Import, it is very configurable, and can do everything you have asked for. (It costs some money however.)
As surprising as it may sound, this is your safer option.
wp-content/plugins
folder.wp_posts
table with a non standard post_type
.wp_postmeta
.