Categories

Featured templates

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

Martin Clarke February 10, 2015
Rating: 4.5/5. From 2 votes.
Please wait...

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.

Go for the best theme ever in our collection of PrestaShop templates!

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
Themes for Prestashop
This entry was posted in PrestaShop Tutorials and tagged database, import, prefix, Prestashop, SQL. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket