Support » Fixing WordPress » Converting Localhost to Remote domain

  • Resolved creativecomponent


    I’ve successfully developed a local WP site, running xampplite, and I love the ease of use.

    I’ve worked through a tutorial “Convert A Local WordPress XAMPP Installation Into A Live Site” found here. — An EXCELLENT tutorial.

    However, the problem I’m having is — every asset on my local server is referenced as ‘localhost’. All assets are showing-up correctly, only because I have the same local server running {Hilarious, actually}.

    I changed the two option_name values of ‘siteurl’ and ‘home’ to the correct remote url.

    I’m assuming EVRYTHING in my database is referencing localhost. Is there a way to fix this?


Viewing 5 replies - 1 through 5 (of 5 total)
  • Probably the only place it really matters is the post_content field of the wp_posts table. You can do a search and replace like so, assuming http://localhost/test/directory/ is the old directory and is the new, live directory:

    Of course, you should back up your database before doing anything like this:

    UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://localhost/test/directory/', '');



    Cool. I’ll give this a try.

    I’ve transferred everything from local to a remote dev server, and I’ve gone-through and edited everything by hand, but once this needs to go to production, I’ll need to do it all over again. A batch process seems like the better way, methinks.

    Thank you!



    Worked like a champ! Thanks again!

    I have installed xampp server in my winxp sp2 system. directory used is d:/xampp
    I have also installed wordpress in htdocs of the xampp and put all the wordpress files in a folder “blog”. I had made an index.html file of my own in htdocs folder and made a link there for my wordpress blog. I also removed the default index.php file that is present in htdocs directory(xampp introduction page).

    It works perfectly on my local machine. when i type localhost in my browser, the index.html file created by me appears and when i click on go to my blog link then the wordpress blog page also open well.

    The problem is that when I try to open my wordpress blog globally(means through internet from some other pc). it doesn’t open.My domain name is that I am hosting from my own pc. when I type my domain name in the browser the first index.html file opens but when I click on go to my blog link, it doesn’t work. An 403 Error message appear. what is the problem? How we can solve this problem? Please help me!



    I followed everything in the link perfectly however, even though the main index.php shows up, none of my pages work. Instead, an “Internal Server Error” occurs for all of them. What could I be missing?? Thanks!

    I did notice that I do not have a wp_posts table.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Converting Localhost to Remote domain’ is closed to new replies.