• I backed up the DB on my site and restored it on the following AMI “AWS Marketplace based WordPress powered by Bitnami (HVM) version 4.5.2-0 on Ubuntu 14.04.3 provided by BitRock Inc”

    I followed these steps (taken from wordpress forum)

    I then did the following to reflect the new blog location being on the destination IP:
    1) UPDATE wp_options SET option_value = replace(option_value, ‘https://www.mywebsite.com’, ‘https://myipaddress’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’

    To fix the urls of posts and pages. I ran the following SQL:
    2) UPDATE wp_posts SET guid = replace(guid, ‘https://www.mywebsite.com’,’https://myipaddress’);

    If I had any internally linked within blog posts or pages with absolute URLs, these links will point to wrong locations after moving the blog location. So I run the following SQL to fix this issue:
    3) UPDATE wp_posts SET post_content = replace(post_content, ‘https://www.mywebsite.com’, ‘https://myipaddress’);

    4) Then renamed the wp-config.php file on destination server.

    5) Then visited https://myipaddress and clicked ‘Create a Configuration File’ button.

    6) Filled in all the following details
    Database Name:
    Username:
    Password:
    Database Host:
    Database Prefix:

    7) It presented me the contents and asked me to copy and paste these contents in a file and name it as wp-config.php as it was not able to create the file directly.

    8) After creating the file I proceeded with the setup and it redirected me to https://myipaddress, however the page was completely blank (no errors, no content or anything. Just plain white blank page)

    9) I tried to go to https://myipaddress/wp-admin and it gives the following message:

    No Update Required
    Your WordPress database is already up-to-date!

    And the only option I get is a continue button

    Also at this point I noted that the URL changes to

    https://www.mywebsite.com/wp-admin/upgrade.php?_wp_http_referer=%2Fwp-admin%2F

    AS soon as i click on continue, I am redirected to original website… that’s

    https://www.mywebsite.com

    I am not sure how to display the contents of my restored site. Nor I know how to login to admin panel now.

    Please help!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi there

    Do you still have the backup available? I suggest starting from scratch.

    Unzip contents to your public_html folder

    Open your SQL file in a text editor and find & replace instances of :

    https://www.mywebsite.com with https://ipaddress
    https://mywebsite.com with https://ipaddress

    Upload your SQL to your database

    Update your database info in your existing wpconfig.php


    Side note: If you have any theme settings etc. you need to export then import this separately.

    Let me know if you need additional help.

    All the best!

    Thread Starter aadilholy

    (@aadilholy)

    Yes, it worked after doing it from scratch. Not sure where I went wrong the first time.

    I managed to restore two different websites successfully

    thanks epicdevspace ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restored site from backup redirecting to main site without A record update’ is closed to new replies.