# Creating new site
**URL:** https://community.kinsta.com/t/creating-new-site/1408
**Category:** Application Support
**Created:** [April 7, 2022, 10:04am UTC](https://community.kinsta.com/t/creating-new-site/1408 "2022-04-07T10:04:59Z")
**Posts on this page:** 11
**Page:** 3
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 3:56pm UTC](https://community.kinsta.com/t/creating-new-site/1408/41 "2022-04-12T15:56:38Z")
However when trying to see my local website, it keeps redirecting me to the live website…
---
### Author:  [@DavidG](https://community.kinsta.com/u/DavidG)
#### Post date: [April 12, 2022, 3:58pm UTC](https://community.kinsta.com/t/creating-new-site/1408/42 "2022-04-12T15:58:39Z")
Ah I didn’t think about that. Sorry for the oversight.
Its caused by the export coming from your live site and not having the values replaced.
The simple fix would be to update the siteurl and home values in the \_options table, though there will be additional links still pulling from your live site instead of sitename.local.
Give me a few minutes to see if I can get a SQL query together that will update the values throughout the database.
---
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 4:00pm UTC](https://community.kinsta.com/t/creating-new-site/1408/43 "2022-04-12T16:00:46Z")
Ah, makes sense.
Thanks!
---
### Author:  [@DavidG](https://community.kinsta.com/u/DavidG)
#### Post date: [April 12, 2022, 4:08pm UTC](https://community.kinsta.com/t/creating-new-site/1408/44 "2022-04-12T16:08:54Z")
You’re welcome.
I DM’ed you a query that should take care of most of those.
It can be run in the database by clicking SQL Command in the top left, pasting it in, and Execute.
After its updated, you’ll want to check in a fresh incognito/private browser session (or fully clear your browser cache) as the existing redirect will likely be stored in your browser.
---
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 4:13pm UTC](https://community.kinsta.com/t/creating-new-site/1408/45 "2022-04-12T16:13:16Z")
I’m getting errors
---
### Author:  [@DavidG](https://community.kinsta.com/u/DavidG)
#### Post date: [April 12, 2022, 4:14pm UTC](https://community.kinsta.com/t/creating-new-site/1408/46 "2022-04-12T16:14:38Z")
Could you check and see if your posts and postmeta tables are there and what their prefix may be?
The default prefix on my site is wp\_ but its possible yours is different.
---
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 4:16pm UTC](https://community.kinsta.com/t/creating-new-site/1408/47 "2022-04-12T16:16:45Z")
its mod650\_posts
I believe the prefix is mod650\_ for all my tables
---
### Author:  [@DavidG](https://community.kinsta.com/u/DavidG)
#### Post date: [April 12, 2022, 4:17pm UTC](https://community.kinsta.com/t/creating-new-site/1408/48 "2022-04-12T16:17:56Z")
That should be the case on your live site in MyKinsta, though in DevKinsta it can/should be different.
If its the same in DevKinsta that’s ok though. Easy to update the query.
Just change `wp_` to `mod650_` in the few places its used.
---
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 4:21pm UTC](https://community.kinsta.com/t/creating-new-site/1408/49 "2022-04-12T16:21:14Z")
Ok David, we finally made it (for now).
Website is just like the live website.
Now, would I have to go through all this everytime? In case I would want to pull the latest version for example from the live website?
Maor
---
### Author:  [@DavidG](https://community.kinsta.com/u/DavidG)
#### Post date: [April 12, 2022, 4:30pm UTC](https://community.kinsta.com/t/creating-new-site/1408/50 "2022-04-12T16:30:49Z")
I’m glad to hear it and do apologize for the road to get here.
I’ve shared all your details with the devs, so they can continue having a look into this. The logs you provided help, but I believe the rsync details may have pushed some of the related DB information out of the file.
I started setting up a reproduction of your setup with the non-prefixed tables and will be testing that today to see if its related.
As for having to go through this again if you want to update the site, I can’t say for sure as we don’t really know the cause of this just yet. I’ll let you know what we can determine of course.
Until then…knowing the manual process works, if you do need to update the site I can help streamline that a bit next time if you need help.
---
### Author:  [@Maor\_Benzvi](https://community.kinsta.com/u/Maor_Benzvi)
#### Post date: [April 12, 2022, 5:07pm UTC](https://community.kinsta.com/t/creating-new-site/1408/51 "2022-04-12T17:07:07Z")
Alright.
In case you need anything from my side to solve this issue, let me know.
I’d be happy to share information/files.
Thanks for the help again.
Maor
[Previous page](https://community.kinsta.com/t/creating-new-site/1408.md?page=2)