My SQL – Website duplication

  • MrAWood

    (@mrawood)


    13 years, 2 months ago

    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

    (@basszje)

    13 years, 2 months ago

    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

    (@mrawood)

    13 years, 2 months ago

    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

    (@chrisl_57)

    13 years, 2 months ago

    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 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) 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.