Featured templates

Joomla. How to change database tables prefix in SQL file

Alex Ross July 18, 2012
Rating: 5.0. From 2 votes.
Please wait...

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

1. If you import the dump file to your database and nothing happens on your website, you should check the database table prefix used for your Joomla installation. Go to Site > Global configuration and click on Server tab

2. Check the field "Database Tables Prefix" and copy the prefix from there.

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.

5. Check your website, it should work properly now.

Feel free to check the detailed video tutorial below:

Joomla. How to change database tables prefix in SQL file

HTML5 Joomla Templates
This entry was posted in Joomla! Tutorials and tagged change, joomla, prefix, SQL. 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