Support » Fixing WordPress » wp_postmeta settings after transfer

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Move *ALL* tables you your new site; don’t pick and choose.

    Use this script to search for http://oldexample.com and replace with http://example.com

    https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

    Yes, I’m sure I’d have to have all the necessary tables.

    ‘and no, I’m not interested in a script for the moment.

    If anyone can help me with the proper related terminology (keywords) with which to better search for a solution it’d be appreciated.

    ‘am at a loss for finding the right direction within the wordpress.org pages.

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    and no, I’m not interested in a script for the moment.

    That script (or plugins based on it, or wp-cli) is necessary if you’re moving tables and changing domains.

    To move a site:

    1. Disable all caching plugins.
    2. Copy files from source to target (usually via your PC via FTP)
    3. Export the database via phpmyadmin.
    4. On the target, create a database and import the DB from the previous step.
    5. Adjust the database information in wp-config.php as necessary.
    6. If changing the domain, use the interconnecit script.

    Okay, thank you Steve for trying to be helpful.

    So can you help me understand why, after bringing in the wp_postmeta are the images not accessible anymore from within my posts and such?

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Did you change the domain? if so, the links point to the old domain.

    No, it’s the same domain. Merely different folders.

    Sans the wp_postmeta table I can see the images since the new install’s posts are pointing to the old media uploads folder.

    Yet obviously I want things to be right and have the media within the new install. ‘and I’m getting stuck with that.

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    if it’s just a folder name embedded in the URL, you could also use the script to change that.

    I somehow imagined this to be a task for phpAdmin

    I just don’t know the steps or what and where exactly needs to be changed en-mass or singularly.

    ‘and I’m sure I can look up the steps for changing values within phpAdmin since I vaguely recall having doing some-such long ago.

    Like I said, I just don’t where exactly they need to be changed.

    • This reply was modified 1 year, 11 months ago by lcerura.
Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘wp_postmeta settings after transfer’ is closed to new replies.