Categories

Featured templates

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

Ryan DeWitt April 20, 2016
Rating: 5.0/5. From 3 votes.
Please wait...

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
Premium Prestashop Themes
This entry was posted in PrestaShop Tutorials and tagged database, dump.sql, prefix, Prestashop. 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