MySQL transfer help

Trying to transfer my database from http://www.howardcountychildrenscenter.com/wordpress to http://www.howardcountychildrenscenter.com/

so basically from a subfolder to the root. The files have already been moved and a new database created. The problem is i need to change all the urls to reflect the new address. I keep getting errors on my sql queries i try…usually about some character is in the wrong spot…on 2 of 3 different one’s i’ve tried such as: 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’);

or this: SET @from_host = ‘www.oldhost.com’;

SET @to_host = ‘www.newhost.com’;

UPDATE wp_options SET option_value = REPLACE(option_value, @from_host, @to_host);

UPDATE wp_posts SET guid = REPLACE(guid, @from_host, @to_host);

UPDATE wp_posts SET post_content = REPLACE(post_content, @from_host, @to_host);

UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, @from_host, @to_host);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, @from_host, @to_host);

UPDATE wp_links SET link_url = REPLACE(link_url, @from_host, @to_host);

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

UPDATE wp_commentmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

here is the exact error for the 2nd one:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 18
STR: ‘
SQL: SET @from_host = \’www.oldhost.com\’;

SET @to_host = \’www.newhost.com\’;

UPDATE wp_options SET option_value = REPLACE(option_value, @from_host, @to_host);

UPDATE wp_posts SET guid = REPLACE(guid, @from_host, @to_host);

UPDATE wp_posts SET post_content = REPLACE(post_content, @from_host, @to_host);

UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, @from_host, @to_host);

UPDATE wp_comments SET comment_content = REPLACE(comment_content, @from_host, @to_host);

UPDATE wp_links SET link_url = REPLACE(link_url, @from_host, @to_host);

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

UPDATE wp_commentmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

SQL query:

SET @from_host = \’www.oldhost.com\’; SET @to_host = \’www.newhost.com\’; UPDATE wp_options SET option_value = REPLACE(option_value, @from_host, @to_host); UPDATE wp_posts SET guid = REPLACE(guid, @from_host, @to_host); UPDATE wp_posts SET post_content = REPLACE(post_content, @from_host, @to_host); UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, @from_host, @to_host); UPDATE wp_comments SET comment_content = REPLACE(comment_content, @from_host, @to_host); UPDATE wp_links SET link_url = REPLACE(link_url, @from_host, @to_host); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host); UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, @from_host, @to_host); UPDATE wp_commentmeta SET meta_value = REPLACE(meta_value, @from_host, @to_host);

MySQL said:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘\’www.oldhost.com\’;

SET @to_host = \’www.newhost.com\’;

UPDATE `wp_opti’ at line 1

thanks for your help!