Forums

[resolved] Import SQL dump to new host, lost access to site (4 posts)

  1. gurang
    Member
    Posted 11 months ago #

    I wanted to move my site to a new host. I backed up my existing site using an SQL dump. I installed a new SQL database and WordPress install on the new host using Fantastico. Then I imported my SQL dump file using phpMyAdmin. PhpMyAdmin reported that the import was sucessful. All looks fine when I examine the directory in file manager. But when I go to the URL for the site, it does not load. When I try to access WP-Admin I sometimes get a redirect to my old host so there must be a problem with my installation, but I can't figure out what it is. The site is http://myphilippinelife.com

    Before I imported the SQL dump, the site worked fine.

    Any ideas?

  2. Samuel B
    moderator
    Posted 11 months ago #

    use this plugin to replace instances of your old url with new url
    http://wordpress.org/extend/plugins/search-and-replace/

    if you go here and hover on site link you can see it still shows old url value
    http://myphilippinelife.com/wp-login.php

  3. gurang
    Member
    Posted 11 months ago #

    Samuel B. Many thanks for the tip. The search-and-replace plugin sounds just like what I need, but how can I run it if I don't have access to my site and hence WordPress admin? When I try to log in to myphilippinelife.com as admin I am redirected to the original goiloilo.com site. Is there a work around?

    Thanks! Bob

  4. gurang
    Member
    Posted 11 months ago #

    I was able to gain access by editing my SQL data base using phpMyAdmin as described at http://codex.wordpress.org/Changing_The_Site_URL

    Thanks again!

Reply

You must log in to post.

About this Topic