Duplicate Site

You must be change your path in database

old path https://www.audioplus.co.uk
with new path https://www.audioplus.co.uk/Wordpress/wordpress/

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 7 years, 9 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,’https://www.audioplus.co.uk’,’https://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,’https://www.audioplus.co.uk’,’https://www.audioplus.co.uk/Wordpress/wordpress’))

SQL query:

UPDATE wp_postmeta SET meta_value = replace(meta_value,’https://www.audioplus.co.uk’,’https://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.uka€?,a€?https://www.audioplus.co.uk/Wordpress/wordpressa€?))’ at line 1

Hi Ellacopter,

I have checked source code from browser and its showing still old path.

See below.

<link rel=”stylesheet” href=”https://www.audioplus.co.uk/wp-content/themes/primepress/style.css&#8221; type=”text/css” media=”screen” />
<link rel=”stylesheet” href=”https://www.audioplus.co.uk/wp-content/themes/primepress/custom.css&#8221; type=”text/css” media=”screen” />

Please update it manually from wp_options table with “siteurl” and “home”.

• This reply was modified 7 years, 9 months ago by Hiren Purohit.

You can use below sql queries to update urls in database.

UPDATE wp_options SET option_value = replace(option_value, ‘https://oldpath&#8217;, https://newpath&#8217;) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

UPDATE wp_posts SET guid = replace(guid, ‘https://oldpath&#8217;,https://newpath&#8217;);

UPDATE wp_posts SET post_content = replace(post_content, ‘https://oldpath&#8217;, https://newpath&#8217;);

UPDATE wp_postmeta SET meta_value = replace(meta_value,’https://oldpath&#8217;,https://newpath&#8217;);

Thanks

Thanks Hiren,

Those sql queries are producing errors. ANy idea why?

https://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