WordPress.org

Ready to get started?Download WordPress

Forums

WP Looks Like Fresh Install After Moving Files To New Domain (7 posts)

  1. betholsoncreative
    Member
    Posted 1 year ago #

    I'm really baffled on this one guys.
    I followed the Codex (and about a dozen other tutorials) to move my blogsite.com to website.com/blog.

    I use Filezilla to ftp all the blogsite.com worpress files to the new website.com/blog location and everytime I log into the wp-admin for the new location it looks like a fresh install and doesn't show any posts/pages/themes. I double checked the wp-config to make sure it was pointing to the right database and checked that database to make sure it has the right siteurl and home listed.

    Still nothing. Anyone ever come across this problem before? Ideas? Thoughts?

  2. esmi
    Forum Moderator
    Posted 1 year ago #

    Did you remember to change the site urls before you carried out the folder move?

  3. betholsoncreative
    Member
    Posted 1 year ago #

    Thanks Esmi,
    No I didn't change them because I didn't want the blogsite.com to go down. (in case I ran into any problems during the move, ha ha)

    I did however go to the database table wp-config and change the url it points to there as the wordpress codex explains how to do. That didn't seem to change anything.

  4. esmi
    Forum Moderator
    Posted 1 year ago #

    If you want to keep both sites up for a short while. you'll need to make a backup of the old database, create a new database (and user) and import the old backup. Then edit the home and site urls in the new database and edit wp-config.php on the new site to point to the new database.

    Does that make sense?

  5. betholsoncreative
    Member
    Posted 1 year ago #

    I thought I had done that before but I'll delete the "new" database and start from scratch. I might have missed a step there, I'll check back in and let you know how it goes!

  6. betholsoncreative
    Member
    Posted 1 year ago #

    hmmmmm, I'm not sure what the deal is but that didn't seem to work either. I exported the database from the old site (via mysql) then went to the new database and tried to import. The first time around it gave me this error: #1044 - Access denied for user 'username1'@'localhost' to database 'username2'

    I read online that this might mean that the user name needs to be changed to the one for the new database so I did a 'find/replace' on the database names (in a text editor) then tried again to upload. This time I received this error: #1007 - Can't create database 'jlblog2'; database exists.

    Now I'm not sure if I should change something else or go back to square one and do something different.

  7. betholsoncreative
    Member
    Posted 1 year ago #

    HOLY COW! I figured it out, totally by accident but it's working!

    I exported the database from the old blog. Opened it in a text editor and then deleted this line: CREATE DATABASE tips_tricks DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; (where'tips_tricks' is the old database name)

    Then the line that follows that: USE tips_tricks;
    change 'tips_tricks' to your new database name.

    I had to do this in 2 places in the database for it to work (there are two locations where 'CREATE DATABASE' and 'USE' existed).

    Thanks for helping me get back on the right track!

Topic Closed

This topic has been closed to new replies.

About this Topic