Site Migration Issues

  • Resolved emilycarney

    (@emilycarney)


    9 years, 3 months ago

    I’m having issues migrating a demo site to its new URL (holisticsbylana.com) (both sites hosted through godaddy).

    When I try to access the wp-admin page I get a 404 File Not Found error and the site URL redirects to this: https://holisticsbylana.com/wp-admin/holisticsbylana.com/wp-login.php?redirect_to=http%3A%2F%2Fholisticsbylana.com%2Fwp-admin%2F&reauth=1

    so I then access the wp-login page which shows up just fine, but when I try to login the URL redirects to this: https://holisticsbylana.com/holisticsbylana.com/wp-admin/
    and I get another 404 File Not Found error,

    so I take the extra name out of the url (it’s now holisticsbylana.com/wp-admin) and the dashboard shows up (because I logged in via wp-login), but without any formatting (white background with plain expanded menu links on the left hand side of the page).

    I backed up/copied all the old site’s WP files, exported the old database, created a new database in the new site, edited the new wp-config file to point to the new database, username, etc., transferred the copied WP files to the new site’s root directory (and I’ve reuploaded them a few times via FTP to see if it was a transfer issue), cleared my cache, disabled my plugins, and tried creating/deleting the .htaccess file, but nothing has worked so far.

    For the dashboard formatting issue, I was able to do this,
    “Try adding this to the wp-config.php: define(‘CONCATENATE_SCRIPTS’, false); before this line: require_once. First, make sure that your browser has JavaScript enabled,”
    and it brought the formatting back to normal, but when I would go to edit a post/page, the text in the text-editor wouldn’t show up unless highlighted (almost as if the font was white?) so I removed the new code from wp-config hoping to find another solution.

    Everything is working completely fine on the old/demo site, so I’m assuming I did something wrong with the migration to cause these issues? but I’m not sure what…

    any help/advice?

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

  • …new database in the new site, edited the new wp-config file to point to the new database, username, etc., transferred the copied WP files to the new site’s root directory

    All of that is fine, and now you need to go to cPanel > phpMyAdmin and give the database the new URL:

    cPanel > phpMyAdmin SQL
    note: Edit ‘pref’ (three places below) to your own table_prefix and change ‘https://www.olddomain.com’ and ‘https://www.newdomain.com’ as required (three places each and with no trailing slashes)

    UPDATE pref_options SET option_value = replace(option_value, 'https://www.olddomain.com', 'https://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE pref_posts SET guid = replace(guid, 'https://www.olddomain.com', 'https://www.newdomain.com');
UPDATE pref_posts SET post_content = replace(post_content, 'https://www.olddomain.com', 'https://www.newdomain.com');
    Thread Starter emilycarney

    (@emilycarney)

    :):) Thank you SO much leejosepho- that fixed everything! I didn’t realize there were more places in the database I needed to replace the old URL other than the wp-options table. Super appreciated!

    I didn’t realize there were more places in the database I needed to replace the old URL other than the wp-options table.

    I am not certain about this, but I think that might get done for you if the change is made at Dashboard > Settings > General (thereby breaking the site) just prior to exporting the tables for use elsewhere and/or leaving the database where it is and moving the wp-folders and wp-files.php to where the different URL either is or will be landing.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Site Migration Issues’ is closed to new replies.