Links messed up after change of directory

I would say yes. I have successfully move my WordPress before and I think I know how to do it.
What I did this time was dragging the folder to another directory. Then updated the directory at the wp-config.php. Then go to the phpmyadmin and in my database I ran the SQL query to change the url like the following:

UPDATE wp_options SET option_value = replace( option_value, 'http://www.dongphotography.ca', 'http://www.dongyuesu.com/photography' ) WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.dongphotography.ca','http://www.dongyuesu.com/photography');

UPDATE wp_posts SET post_content = replace(post_content, 'www.dongphotography.ca','http://www.dongyuesu.com/photography');