How to Import PodPress Audio URLs

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:

  1. 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.)
  2. Go into the old site’s phpMyAdmin and export the “wp_postmeta” and “wp_posts” tables.
  3. 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.)
  4. In the new site’s phpMyAdmin, run the following query:

    REPLACE
    INTO wp_posts
    SELECT *
    FROM wp_ww_posts
    ;

  5. That did it for me. How about you?

    (Thanks, FCW and NTM!)

The Mighty Mo! Design Co.

RSS From Toby’s Blog

More posts from themightymo.com

WordPress Support

The Ultimate Guide to WordPress Support: Why it’s Essential for Your Website’s Success

By The Mighty Mo! Design Co. | September 25, 2023

Whether you’re situated in Minneapolis, St. Paul, Illinois, New York, or any other corner of the globe, ensuring reliable WordPress Support is paramount for the continued success of your website. In this comprehensive guide, we will delve into the crucial role that WordPress support plays in your website’s journey to success.

sem rush log file analyzer

How to optimize your Google Crawl Budget using SEM Rush Log File Analyzer and Rank Math SEO

By The Mighty Mo! Design Co. | September 22, 2023

Today I ran the SEM Rush Log File Analyzer tool, and it showed some interesting things that are a complete waste of our Google Crawl Budget. Specifically, I learned that Google is wasting some of our crawl budget on the /wp-includes/ directory, certain plugin directories, and cache directories. I also noticed random files being crawled…

google analytics definitive guide

Where is the Google Analytics Measurement ID?

By Toby Cryns | August 16, 2023

In the vast, evolving world of web development and analytics, keeping up with terminologies and tools can sometimes feel like trying to chase a mischievous cat in a maze. You think you’ve got a grip, only for it to slip right through your fingers! Enter the mysterious “Measurement ID” from Google Analytics 4 (GA4), a…

RSS From Toby’s Blog