Move WordPress to new Database

  • stephanium

    (@stephanium)


    9 years, 8 months ago

    I’m trying to move WordPress to a new Database.

    I’ve created a new database “WPDB” hosted on the same server as the old database. Afterwards I migrated all tables with their content into the new database. The table-names still are the same. The user which wordpress is using to Access the database is owner of my new Database.

    Afterwards I edited “wp-confgig.php” and changed the database name to “WPDB”. The user, password, host etc. still are the same.

    After these changes my WordPress-blog isn’t available anymore. The Site is just loading and no Content at all appears (“Site not available”). Anyone got an idea, what I’m doing wrong?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Bob Cristello

    (@gntmidnight)

    9 years, 8 months ago

    1. It would probably be helpful, in the future, if you were to provide a URL to look at.
    2. These are all just guesses, since I can’t see exactly what is going on.
    3. Is the user you created assigned to the new database in your control panel?
    4. Does the user you assigned to the database have full permissions for the database?
    5. Are you using a shared hosting system such as godaddy that might require the use of a specific server location instead of using localhost?
    6. If you change your wp-config to point back to the original database does the site work?

    These are the questions I would be asking first when troubleshooting.

    Thread Starter stephanium

    (@stephanium)

    9 years, 8 months ago

    I can’t provide an URL, because the site isn’t reachable from the internet.
    I’m using a domain user, which is Owner of the new and old database.
    The database is hostet on a Server not localhost. The new database is hosted on the same server like the old database.
    I’m not using a shared hosting system.
    When I Change wp-config back to the original database the site works again.
    I migrated all tables with all data of the old database. The table names still are the same.

    When I try to call my blog with the new database, it tries about 2 minutes to load the page and then in IE following error appears:
    This page can’t be displayed
    •Make sure the web address <<URL>> is correct.
    •Look for the page with your search engine.
    •Refresh the page in a few minutes.

    I just checked with Chrome and Firefox. There following error appears: “This webpage has a redirect loop”

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Move WordPress to new Database’ is closed to new replies.