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.

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

   

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

   

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:

   

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

   

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

   

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:

   

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

   

Feel free to check the detailed video tutorial below: