Thank you for replying!
I’ve done that within wp_posts and wp_options
Do I need to do it elsewhere?
-
This reply was modified 8 years, 11 months ago by
ellacopter.
Hi Ellacopter
Yes, you need to do same in wp_postmeta as well.
Execute below query in phpmyadmin
UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.audioplus.co.uk’,’http://www.audioplus.co.uk/Wordpress/wordpress’);
Hi Hiren,
Thank you so much.
I tried that and got this error:
Error
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: Unknown Punctuation String @ 61
STR: ://
SQL: UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.audioplus.co.uk’,’http://www.audioplus.co.uk/Wordpress/wordpress’))
SQL query:
UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.audioplus.co.uk’,’http://www.audioplus.co.uk/Wordpress/wordpress’))
MySQL said: Documentation
#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.audioplus.co.uk’,’http://www.audioplus.co.uk/Wordpress/wordpress’))’ at line 1
Hi Ellacopter,
I have checked source code from browser and its showing still old path.
See below.
<link rel=”stylesheet” href=”http://www.audioplus.co.uk/wp-content/themes/primepress/style.css” type=”text/css” media=”screen” />
<link rel=”stylesheet” href=”http://www.audioplus.co.uk/wp-content/themes/primepress/custom.css” type=”text/css” media=”screen” />
Please update it manually from wp_options table with “siteurl” and “home”.
You can use below sql queries to update urls in database.
UPDATE wp_options SET option_value = replace(option_value, ‘http://oldpath’, http://newpath’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘http://oldpath’,http://newpath’);
UPDATE wp_posts SET post_content = replace(post_content, ‘http://oldpath’, http://newpath’);
UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://oldpath’,http://newpath’);
Thanks
Thanks Hiren,
Those sql queries are producing errors. ANy idea why?
http://www.audioplus.co.uk/Wordpress/wordpress/
The website now loads here. But I can’t access the dashboard.
Any clues? I really appreciate all the help
Hi Ella, I’m not sure what hosting site you’re using, but the following video is a very helpful step by step guide to duplicating a wordpress website that is hosted on Bluehost:
https://youtu.be/opYeHPMBh5g
