{"id":2606,"date":"2013-04-12T18:05:25","date_gmt":"2013-04-12T22:05:25","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/04\/12\/change-site-url-in-database\/"},"modified":"2022-03-11T11:11:05","modified_gmt":"2022-03-11T16:11:05","slug":"change-site-url-in-database-prestashop","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/","title":{"rendered":"How to change your site URL in the database of PrestaShop 1.5"},"content":{"rendered":"

If your domain name changes for whatever reason, you will need to make this change in the PrestaShop backoffice (337: How to change your shop URL in PrestaShop 1.5<\/strong><\/a>). However, access to change the URL may not always be available through the dashboard. To accommodate this possibility, you can make the change directly in the mySQL database. The following article walks you through the steps for making this change using phpMyAdmin.<\/p>\n

Modify the Shop URL in the Database using phpMyAdmin<\/h2>\n
    \n
  1. Login to your cPanel<\/a>.\n
    <\/div>\n<\/li>\n
  2. Scroll down to the database section and click on phpMyAdmin<\/strong>.\n
    <\/div>\n<\/li>\n
  3. \"Select<\/a>\n
  4. \"Select<\/a>\n
    <\/div>\n

    When the database is open, scroll down the left side until you see the table labeled \u201ctableinitals_shop_url\u201d. Table initials <\/em>usually default to \u201cps\u201d but can be changed to something else during the installation process. Click on this table to select and open it. You will see the option to EDIT this table at left (as indicated in the screenshot at right).<\/p>\n

    <\/div>\n<\/li>\n
  5. \"Edit<\/a>\n
    <\/div>\n

    Click on EDIT<\/strong> and then change the URL entries. Make sure to change both the entries with the appropriate URL. If you aren\u2019t sure about the SSL or you are not using it, simply use the same one.<\/p>\n

    <\/div>\n<\/li>\n
  6. \"Scroll<\/a>\n
    <\/div>\n

    Click on GO<\/strong> at the bottom of the page in order to save your entries.<\/p>\n

    <\/div>\n<\/li>\n<\/ol>\n

    The change of the shop URL in the database should only be done as necessary because it will affect ALL links within the shop.<\/p>\n

    If you have FRIENDLY URLs<\/strong> set, then you will need to turn this option off, save the change, then turn it back on in order to set the updated URLs in the database. For more information on setting Friendly URLs, go to How to set up Search Engine Friendly URLs in PrestaShop 1.5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    If your domain name changes for whatever reason, you will need to make this change in the PrestaShop backoffice (337: How to change your shop URL in PrestaShop 1.5). However, access to change the URL may not always be available through the dashboard. To accommodate this possibility, you can make the change directly in the Read More ><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[92],"tags":[],"class_list":["post-2606","post","type-post","status-publish","format-standard","hentry","category-prestashop"],"acf":[],"yoast_head":"\nHow to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-12T22:05:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-11T16:11:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\"},\"headline\":\"How to change your site URL in the database of PrestaShop 1.5\",\"datePublished\":\"2013-04-12T22:05:25+00:00\",\"dateModified\":\"2022-03-11T16:11:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\"},\"wordCount\":343,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png\",\"articleSection\":[\"Prestashop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\",\"name\":\"How to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png\",\"datePublished\":\"2013-04-12T22:05:25+00:00\",\"dateModified\":\"2022-03-11T16:11:05+00:00\",\"description\":\"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png\",\"width\":818,\"height\":384,\"caption\":\"Select Select the database in phpMyAdmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to change your site URL in the database of PrestaShop 1.5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting","description":"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/","og_locale":"en_US","og_type":"article","og_title":"How to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting","og_description":"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-04-12T22:05:25+00:00","article_modified_time":"2022-03-11T16:11:05+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b"},"headline":"How to change your site URL in the database of PrestaShop 1.5","datePublished":"2013-04-12T22:05:25+00:00","dateModified":"2022-03-11T16:11:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/"},"wordCount":343,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png","articleSection":["Prestashop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/","name":"How to change your site URL in the database of PrestaShop 1.5 | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png","datePublished":"2013-04-12T22:05:25+00:00","dateModified":"2022-03-11T16:11:05+00:00","description":"Learn how to change your URL for Prestashop 1.5 directly in the database. You can use a database client like phpMyAdmin to quickly and easily make the change.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/04\/edu_prestashop1.5_change-url_prestashop154-db-list.png","width":818,"height":384,"caption":"Select Select the database in phpMyAdmin"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/change-site-url-in-database-prestashop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to change your site URL in the database of PrestaShop 1.5"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2606"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2606\/revisions"}],"predecessor-version":[{"id":95041,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2606\/revisions\/95041"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}