When you have developed your retail website under a dev server or in your local workstation, you would need to move your Prestashop 1.7 e-commerce website to a new domain. A database is a piece of software application that Prestashop 1.7 uses to store most of the information related to your inventory, your orders or your customers.    

In this Prestashop tutorial, we will guide through the steps to update your database connection.

Prerequisites:

Get the new database connection settings ready

Upload an up to date database backup file within the target database instance.

Install an application like FileZilla if you don’t already have an FTP client application.

Setting up a new Database in Prestashop 1.7

You could update your Prestashop files via an FTP connection or directly from your domain cPanel application. We recommend the first method.

Use your FTP credentials to connect to your website.  Once connected, navigate to the file:

/app/config/paramaters.php

Download the file in your local computer. Edit the file parameters.php with a simple text editor like Notepad++.

Look for the parameters:

  • Database_host
  • Database_name
  • Database_user and
  • database_password

Replace every single of the parameters with the new ones that Save the file to apply the updates and upload the file to replace the old parameters.php document.

Prestashop 1.7 database settings

It is as simple as that. Your website should be up and running again. Get access to your Prestashop 1.7 Frontend to test.