Need Quick Help Transferring WP BLog

Discussion in 'WordPress' started by shkad14, May 21, 2009.

0
  1. #1
    OK. I transferred all the files to the new account. I went in a nd created a database and imported the files. However, nothing is happening.

    What am I doing wrong?

    www.howtoviolin.com/blog
     
    shkad14, May 21, 2009 IP
  2. sylv3rblade

    sylv3rblade Peon

    Messages:
    292
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #2
    http://www.howtoviolin.com/blog/index.php is giving a 404 error
    plus, since the page is listing ALL of it's contents it's kinda telling what the problem is.
    You didn't get ALL your files from the previous server to upload to the new one.
     
    sylv3rblade, May 21, 2009 IP
  3. vrktech

    vrktech Well-Known Member

    Messages:
    449
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #3
    your old blog was in root directory howtoviolin.com but now you have uploaded it to howtoviolin.com/blog so you will need to go to the database and look at wp_options table and change the blog url to howtoviolin.com/blog, after that you can be able to login to the site properly,

    Contact me if you need more help,
     
    vrktech, May 21, 2009 IP
  4. wrs

    wrs Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Here's a good post. It helped me last time I had to do this.
    Cheers
    Brian

    http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-
    new-domain-or-location/

    To update WordPress options with the new blog location, use the following SQL command:

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

    After that you will need to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field. The URL values in this field are stored as absolute URLs instead of relative URLs, so it needs to be changed with the following SQL query:

    UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

    If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. Use the following SQL commands to fix all internal links to own blog in all WordPress posts and pages:

    UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

    Browse through WordPress blog to check if everything is okay. You also need to re-login to WP Administration as authentication cookie has now became invalid due to different domain.
     
    wrs, May 22, 2009 IP
  5. wrs

    wrs Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    In this particular case it was:

    UPDATE wp_options SET option_value = replace(option_value, 'http://howtoviolin.com', 'http://howtoviolin.com/blog') WHERE option_name = 'home' OR option_name = 'siteurl';


    UPDATE wp_posts SET guid = replace(guid, 'http://howtoviolin.com','http://howtoviolin.com');


    UPDATE wp_posts SET post_content = replace(post_content, 'http://howtoviolin.com', 'http://howtoviolon.com/blog');

    Voila.

    PM me when you get a chance.
    Brian
     
    wrs, May 22, 2009 IP