This tutorial shows how to change database tables prefix in dump.sql file.
Open Prestashop database in database management tool like PhpMyAdmin. Database tables have qenuy76_ prefix in our case:
Open dump.sql file in your editor. Find sql query with database table name. Copy `ps_ database prefix text:
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:
In “Replace with” field you should specify custom prefix along with ` character: `qenuy76_
Now we should replace all instances of `ps_ with `qenuy76_ using "Replace all" button:
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:
Refresh the page. Sample data was imported properly:
Feel free to check the detailed video tutorial below: