SQL Script to run when moving WordPress location

October 1, 2014 David Allan Web, 0

1. Go to the General panel.
2. In the box for Site address (URL): change the address to the root directory’s URL. Example: http://example.com
3. Click Save Changes. (Do not worry about the error message and do not try to see your blog at this point! You will probably get a message about file not found.)
4. Copy (NOT MOVE!) the index.php and .htaccess files from the WordPress (wordpress in our example) sub directory into the root directory of your site—the latter is probably named something like www or public_html. The .htaccess file is invisible, so you may have to set your FTP client to show hidden files. If you are not using pretty permalinks, then you may not have a .htaccessfile. If you are running WordPress on a Windows (IIS) server and are using pretty permalinks, you’ll have a web.config rather than a .htaccess file in your WordPress directory.
5. Edit your root directory’s index.php.
   1. Open your root directory’s index.php file in a text editor
   2. Change the line that says:
      require( dirname( __FILE__ ) . '/wp-blog-header.php' );
      to the following, using your directory name for the WordPress core files:
      require( dirname( __FILE__ ) . '/wordpress/wp-blog-header.php' );
   3. Save the file.
6. Login to your site (if you aren’t still already). The URL should still be http://example.com/wordpress/wp-admin/
7. If you have set up Permalinks, go to the Permalinks panel and update your Permalink structure. WordPress will automatically update your .htaccess file if it has the appropriate file permissions. If WordPress can’t write to your .htaccess file, it will display the new rewrite rules to you, which you should manually copy into your .htaccess file (in the same directory as the mainindex.php file.)

You may need to

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldurl’,’http://www.newurl’);

UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldurl’, ‘http://www.newurl’);

UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.oldurl’,’http://www.newurl’);

wordpress