I ran into a real bugger of a problem tonight when attempting to import a WordPress site using the Importer plugin. The problem arose, because the importer does not get all of the data out of the “wp_postmeta” table. In fact, it misses or messes up the audio urls that PodPress uses.
The solution I found was the following:
- MAKE A BACKUP OF BOTH YOUR OLD SITE’S AND NEW SITE’S DATABASES!!! (Following the steps below can seriously and permanently mess up your site. Call a WordPress pro if this message scares you. Seriously.)
- Go into the old site’s phpMyAdmin and export the “wp_postmeta” and “wp_posts” tables.
- Go into the new site’s phpMyAdmin and import the “wp_postmeta” and “wp_posts” tables that you just saved in step 1 above. (Note: If your target installation uses the same “wp_” prefix, then you will need to change the title of the tables before importing them.)
- In the new site’s phpMyAdmin, run the following query:
That did it for me. How about you?
More posts from themightymo.com
GoDaddy owns ManageWP, and, strangely, they make it very difficult to add GoDaddy-managed WordPress sites to their ManageWP service. Thankfully, there’s a quick workaround: Visit https://yoursite.com/wp-admin/plugins.php?showWorker=1 — This will make the ManageWP “Worker” plugin visible. Copy the connection info from the ManageWP Worker plugin. Add the site per-normal on ManageWP. That’s it! I hope this…
I realized this morning that my TMM Maintenance Mode WordPress plugin had a bug that was causing the wp-login.php page to be inaccessible. The solution was to write a simple function that checks whether or not we’re currently on a login page, and then add a call to that function in my code. Here’s the…
Today I updated a WooCommerce site, and everything worked fine, except for the images on product pages – they were not displaying at all. After a lot of trial & error, I realized that WP Rocket was to blame. I’m not sure exactly what the issue was (though my hunch is that it had to…