Using the procedure in the Codex, I moved my WP core files from /public_html/mysite/blog to /public_html/mysite. Then I deleted everything in /public_html/mysite/blog. When I browse to mysite.com, everything looks okay.
However when I peek browse the wp-posts table inside my wrdp1 database, the GUID field records still show '/public_html/mysite/blog'.
And when I browse the wp-options table, the records for 'fileupload_realpath' and 'fileupload_URL' also contain /public_html/mysite/blog/wp-content.
Is this normal and I just need to manually edit those records, or did something not go right in the transfer?