changed domain name

  • Resolved dougmiller

    (@dougmiller)


    10 years, 10 months ago

    Hi Tobias,
    I’ve searched the forum and can’t find the answer to a question which has probably been asked before, so I apologise for that.

    We’ve moved our site to a new domain and our hosting company have redirected our WP install successfully to the new location.

    We have quite a few image and audio links in Tablepress tables which obviously now point to the ‘old’ domain.

    Is it possible to perform some kind of ‘find and replace’ across all tables to correct the links? Otherwise, we have a long job on our hands re-writing them all manually!

    Example table URL – http://englishlearningtools.com/2273/hotel-general-full-free-lesson

    Thanks
    · Website: http://englishlearningtools.com
    · TablePress: 1.0
    · TablePress (DB): 18
    · TablePress table scheme: 3
    · Plugin installed: 2013/04/15 14:40:30
    · WordPress: 3.6-beta3-24290
    · Multisite: no
    · PHP: 5.3.25
    · mySQL (Server): 5.5.30-MariaDB-log
    · mySQL (Client): 5.0.91
    · ZIP support: yes
    · UTF-8 conversion: yes
    · WP Memory Limit: 40M
    · Server Memory Limit: 256M
    · Magic Quotes: on
    · WP_DEBUG: false

    http://wordpress.org/extend/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    Thanks for your question, and sorry for the late answer. As I was on vacation, I didn’t have a chance to reply earlier.

    Yes, you could do a search and replace in the database here (e.g. in PHPMyAdmin).
    As all URLs in tables are JSON encoded, you will need to take a care of slashes for example.
    That means that you have to search for

    http:\/\/old-domain.com\/

    and replace that with

    http:\/\/new-domain.com\/

    As you can see, each / is escaped with a \.
    Regards,
    Tobias

    Thread Starter dougmiller

    (@dougmiller)

    10 years, 9 months ago

    Many thanks. Hope you had a great holiday. And thanks for the syntax help. We’re not sure whether or not to go ahead with changing all the links. When we changed domain, our host provider simply redirected the WP install to use the new domain url, but the old document root on the server. So, it’s only when users hover images in TablePress that possible confusion could come about as they will see the old address in their browser. It’s a bit of a headache, but it would be nice to get it all ‘straightened out’.
    Again, thanks.

    Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    well, if there’s no urge to change the links, you don’t really have to bother with it, I guess. You could do it anytime in the future, if you have to.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘changed domain name’ is closed to new replies.