Changed main domain with host and lost my site

Hello all. I am needing some help to get my site back on track.

I have a WPMU install with buddypress which is integrated with BBpress.

Due to some business changes I had the host (PSek) change the main domain of my account and now I can not access my site at either domains.

When I go to the new domain that is being used for my account I get the following error-
Access is forbidden to the requested page:
crosseyedgamer.com/wp-signup.php?new=crosseyedgaming.com

Note, I went from crosseyedgamer.com to crosseyedgaming.com.

If you pull up crosseyedgamer.com now you will be going to my current live site on a totally different server so do not even pay attention to that. I was using the install on the PSek server as the new site and thought we were going to use the same domain. That changed and I thought if they changed my account info I would be able to then change things in WP and database myself.

I can access the database and I saw a tutorial online about changing the site urls in the tables which I am ready to try but before that I wanted to see if anyone else had some tips for me.

I don't want to go messing with the database and other settings and end up with a totally wrecked site.

So to sum things up, Same host, Same IP, different domain name. What is needed to get it working again?

I appreciate your help.
Thanks.

UPDATED INFO -- I went into the wp-config.php file and change the site domain to the correct one and when I go to the site now I get the following
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

I cleared all cookies and everything and tried again but got the same thing.

Wasn't sure if this would help with trying to get things worked out or not. Thanks again.

  • Rick Lewis
    • Design Lord, Child of Thor

    Working on that now and so far, site is still in nowhere land. I was hoping if I hit the main site fields it would be good. Let's hope I hit the magic one here soon.

    Is there any issue though with the .htaccess file that could cause me troubles?

    And I assume I needed to change the wp-config.php files site url to the correct one?

    Thanks.

  • Rick Lewis
    • Design Lord, Child of Thor

    Ok I got a site back. Able to pull it up and log in. What I need help with is the proper Query to run in order to replace the old domain in the posts and other tables it is still existing in.

    What I used tells me I have a syntax error. This may not be the place to ask for this type of help but I haven't a clue as I am not expert in this area. If someone can help I would be very thankful.

    Here are the three I am trying to run.

    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’;

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

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

  • Patagonia
    • Design Lord, Child of Thor

    In PHP mY admin, go to your database, export and download as file.
    Open up in Wordpad, CTRL+H and replaca all instances. Save and re-upload using PHP My admin.

    That should do it. Make sure to do back ups (for example easily via PHP My Admin -. Operations -> Copy database.

    Cheers

  • Rick Lewis
    • Design Lord, Child of Thor

    Well, got it downloaded and did the find and replace. Now saving the changed file which has taken so far 40 mins and is about 25% saved.

    And this is on a fairly small database.

    Are there any other options to get this done faster?

  • Patagonia
    • Design Lord, Child of Thor

    Not sure if you have any plugins that generate huge log files?
    Of many spam comments still in the system?
    Delete them all first. Then do what I mentioned above, but select .zipped or .gzipped as file size will be a few % of the original.

    Cheers

  • Rick Lewis
    • Design Lord, Child of Thor

    no there are not many of anything as it is a newer site. it isn't live to anyone.

    Downloading the file isn't all that bad.
    It takes almost 30 mins to open the file on my computer. Making the changes goes fairly quickly but saving the file is just insane. Word has crashed almost every time I have tried it the first time.

    there has to be a better way to do this.

  • Patagonia
    • Design Lord, Child of Thor

    No, don't do anything in word format! Word adds all kinds of formatting and code behind the scenes, which will mess everything up. Never write or edit any code in Word.

    Just open the sql you saved file in WordPad, a free utility that comes with Windows. It might take a while if the file is huge. If it is really enormous, you could cut it into smaller pieces for when you re-upload the edited parts.

    Good luck

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.