I figured it out. In Step 4 in the article I referred to above, the author said to delete the line from the sql script that set the siteurl in wp_options before restoring. This is incorrect because the sql script drops the existing wp_options table before it restores a new one. This leaves wp_options without a siteurl setting. I just edited the siteurl in the sql script before I restored and this fixed it!