Moved site, unable to change url

Hi,
We have moved our site to a new url, but the site automatically redirects back to the old url. We need to change it in the admin, but due to the redirect cannot access the backend. Is there another way, maybe with an sql query or something we can change the url for the site?

Access to database and execute this query.

update [store] set SslEnabled = 0

Then restart application, clear browser cache (if needed) and try to access administration. Go to Configuration > Stores and edit your store properties.

neilzb wrote:


Run below query if your site is secured

update Store
set [Url]='http://youstorname.com/',SslEnabled=1
where Id=1

If not secured then

update Store
set [Url]='http://youstorname.com/'
where Id=1

After executing the query clear the browser cache and access the new URL. You may need to clear the server memory cache after change the url. To do that upload the web.config file again