If this tutorial is not what you were looking for, you still have any questions, suggestions or concerns - feel free to let us know. Please help us to serve you better!

Your Name

Your Email

Your Message (required)

captcha

Featured templates

PrestaShop 1.6.x. How to change database tables prefix in dump.sql file

This tutorial shows how to change database tables prefix in dump.sql file.

PrestaShop 1.6.x. How to change database tables prefix in dump.sql file

  1. Open Prestashop database in database management tool like PhpMyAdmin. Database tables have qenuy76_ prefix in our case:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-1

  2. Open dump.sql file in your editor. Find sql query with database table name. Copy `ps_ database prefix text:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-2

  3. Press CTRL + F in order to open Search and replace window (we are using Notepad++ software). Open Replace tab.
    Paste `ps_ text in "Find what" field:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-3

  4. In “Replace with” field you should specify custom prefix along with ` character: `qenuy76_

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-4

  5. Now we should replace all instances of `ps_ with `qenuy76_ using "Replace all" button:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-5

  6. Save the changes you have performed. Go to Import section of the database management tool. Select customized dump.sql file and import it to the database:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-6

  7. Refresh the page. Sample data was imported properly:

    PrestaShop 1.6.x. How to change database tables prefix in dump.sql file-7

Feel free to check the detailed video tutorial below:

PrestaShop 1.6.x. How to change database tables prefix in dump.sql file