correcting image links after wordpress migration from local host
I followed the instructions on https://www.inmotionhosting.com/support/edu/wordpress/migrating-wordpress-inmotion-hosting/correct-image-links
Here is my line 2:
UPDATE wp_posts SET post_content=(REPLACE (post_content, 'http://localhost:8888/wordpress/','http://biz229.inmotionhosting.com/~stlinu5/'));
I am receiving error code: #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 'UPDATE wp_posts SET post_content=(REPLACE (post_content, 'http://localhost:8888/' at line 2
Can someone tell me what the correct syntax is?
Here is my line 2:
UPDATE wp_posts SET post_content=(REPLACE (post_content, 'http://localhost:8888/wordpress/','http://biz229.inmotionhosting.com/~stlinu5/'));
I am receiving error code: #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 'UPDATE wp_posts SET post_content=(REPLACE (post_content, 'http://localhost:8888/' at line 2
Can someone tell me what the correct syntax is?
Sorry for the issue with the update article for your image links using MySQL. We were looking at the information you provided, and the article only provides one line of code. We're wondering what is on line 1. Did you have something else added to the update query? If so, please provide the complete query that you used. If you can give us more information about the complete query then we can determine why the code is not working.
If you have any further questions or comments, please let us know.
Regards,
Arnel C.