Joomla 3.x. How to change database table prefix in sql file

This tutorial will show you how to change the database table prefix in SQL file in Joomla 3.x.

Joomla 3.x. How to change database table prefix in sql file

Sometimes, after importing sql file you cannot see any changes on the web-site, that means you should check the database prefix. In order to apply the changes, you need to perform the following steps:

1. Go to System > Global configuration and click on Server tab.

2. There you will be able to find “Database Tables Prefix” and copy it up:

   

3. Open your dump.sql file from Sources folder and choose Find & Replace tool. You need to replace all “jos_” instances with your table prefix there. Paste jos_ to the “Find” field and your prefix to the “Replace” field, then click on Replace all button:

   

4. Save the file and import it to your database.

Check your website, it should work properly now. In case any other questions appear, feel free to check our video version below:

Joomla 3.x. How to change database table prefix in sql file