Title: My SQL – Website duplication
Last modified: August 21, 2016

---

# My SQL – Website duplication

 *  [MrAWood](https://wordpress.org/support/users/mrawood/)
 * (@mrawood)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/my-sql-website-duplication/)
 * Hi. I am currently helping a business associate with a problem, but i have gotten
   stuck with something that i cannot find a solution to. Currently, he is running
   a business website which is made specifically for the U.S. He asked me to duplicate
   the same site, so we can alter it for use in the U.K. The website has a bespoke
   template which was designed for us by a 3rd party designer.
 * Here is what i did to copy the website over including here i get stuck.
 * The first thing i did, was set up the new .co.uk domain, then I set up the MySQL
   on my hosting account (with 1and1.com). I extracted the MySQL files from the 
   US database, and then uploaded the MySQL to the new UK database. I amended the
   config.php to the new database details. When I load the UK site up, its comes
   up correctly, but when I try to access it (through /wp-admin), I get a page telling
   me that the installation was complete, and no configuration is required. This
   page has an ‘Ok’ button, and when I click it, it takes me through to the US site!
   Can anyone tell me how this crossover happened, and how to amend it?
 * I have since removed the files again (so there is no website at present) and 
   I am hoping that someone will give me a dummy step-by-step guide on how to sort
   it properly!
 * Any further information can be given on request.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Bas Schuiling](https://wordpress.org/support/users/basszje/)
 * (@basszje)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/my-sql-website-duplication/#post-3648116)
 * You have to change values in the database for the new domain as well.
 * Check in the table ‘wp_options’ for all values that have a domain entered. (siteurl
   for instance )
 * Double-check wp_postmeta as well for any URL pointed to the US site.
 * Plugins may also store site specific information.
 *  Thread Starter [MrAWood](https://wordpress.org/support/users/mrawood/)
 * (@mrawood)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/my-sql-website-duplication/#post-3648117)
 * Ok, so where exactly do i look in the database to change the values, and what
   values do i change?
 * Im a bit of a thickkie when it comes to altering websites on a “genetic” level!
   🙂
 *  [Creatrix](https://wordpress.org/support/users/chrisl_57/)
 * (@chrisl_57)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/my-sql-website-duplication/#post-3648140)
 * You were almost there!
    The problem is that you need to update all of the links
   in the new .co.uk database as they will all still be pointing to the .com domain.
 * To do this i use the [Safe Search and Replace Script](http://interconnectit.com/products/search-and-replace-for-wordpress-databases/)
   which will update all the links for you.
 * You basically need to upload it to your .co.uk domain, visit the address wherever
   you stored it (e.g [http://www.website.co.uk/script.php](http://www.website.co.uk/script.php))
   then follow the steps – i think there’s about four.
 * The final one will ask you what you are looking for and what you want to replace
   it with. So you will be changing ‘website.com’ to ‘website.co.uk’.
 * Be sure you have the .co.uk wp-config file with the .co.uk database details **
   and not** the .com details otherwise you will change all the links in the .com
   database and things will get messy!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘My SQL – Website duplication’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [Creatrix](https://wordpress.org/support/users/chrisl_57/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/my-sql-website-duplication/#post-3648140)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics