[contact-form-7 id="24078" title="Feedback EN"]

Featured templates

PrestaShop 1.6.x. How to change database tables prefix (if necessary) and import SQL file

This tutorial will show you how to change database tables prefix (if necessary) and import SQL file in PrestaShop 1.6.

  1. First you need to edit the settings.inc.php file in the config folder of your website. You can access it via the FTP or cPanel Filemanager. After you opened the file you need to find the following line of code, which specifies your database table prefix:

    define('_DB_PREFIX_', 'xyz_');

    Replace the value in the second quotation marks (in our case it’s ‘xyz_’) with ps_ and save the file. As a result, you’ll have:

    define('_DB_PREFIX_', 'ps_');
  2. Now you need to access the phpMyAdmin tool of your server to work with the database. When you open it you need to select your database on the top left (the name of the database is specified in the settings.inc.php file you edited previously). Then click on Check all to select all the database tables and select Replace table prefix option in the dropdown menu on the right.

    PrestaShop 1.6.x. How to change database tables prefix (if necessary) and import SQL file-1

  3. You will be redirected to the page with 2 fields: From and To. In the From field you need to put an old database prefix, which in our case is equal to “xyz_” and in the To put “ps_”. Then click the Submit button.

    Please, note, that the operation should be repeated for each page of the database (you can select the page right below the Check all option from the previous step).

    PrestaShop 1.6.x. How to change database tables prefix (if necessary) and import SQL file-2

  4. The last step is to import the dump.sql file from the template package into PrestaShop database using the phpMyAdmin tool.

Thank you for reading our tutorial. Now you know how to change database tables prefix (if necessary) and import SQL file in PrestaShop 1.6.

Feel free to check the detailed video tutorial below:

PrestaShop 1.6.x. How to change database tables prefix (if necessary) and import SQL file