Imported a SQL to DB – Not Working

  • estevancarlos

    (@estevancarlos)


    14 years, 6 months ago

    I’m trying to figure out how to move a WordPress site from one server to another. So I’m doing some testing.

    I exported the DB from one WP site. I also copied the theme, plugins and uploads from the previous location. I then installed WP on the new location on the new server. After this I attempted to import the previously downloaded DB. I received an error regarding some duplication with the default “Hello world” post. All in all, it’s not working. The import appears to have imported mostly correctly into the DB. The wp-config file points to my new DB but none of the data is accessible in WordPress. Any suggestions?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter estevancarlos

    (@estevancarlos)

    14 years, 6 months ago

    Actually, I may have done this in the wrong order?

    Pioneer Web Design

    (@swansonphotos)

    14 years, 6 months ago

    See this. Below worked for me:

    1. Upload all copied files (do not copy any cache related files if using cache plugins). Make sure site has been properly setup in DNS and enough time has elapsed in the DNS system (there are other methods to test site using previewdns or hosts files, review the codex and discuss with your web host).
    2. Edit wp-config.php (Using an FTP client, do not access or run WordPress yet.)
    3. Create the new database and import.
    4. Access admin login. Activate theme, activate plugins (some plugins are dependent on others so activate in the proper order if so).

    If you receive errors, something went wrong, re-do all steps.

    I would also remove the Hello World post from first blog then export the db.

    Thread Starter estevancarlos

    (@estevancarlos)

    14 years, 6 months ago

    Hm, not quite. I sort of trying to make a duplicate of one site at a separate location. When I type the new address it automatically redirects to the other, original, location of the website.

    I do not want to change the site URL for the old website because it needs to stay where it is (for the time being). Am I doing something wrong?

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

The topic ‘Imported a SQL to DB – Not Working’ is closed to new replies.