If this tutorial is not what you were looking for, you still have any questions, suggestions or concerns - feel free to let us know. Please help us to serve you better!

Your Name

Your Email

Your Message (required)

captcha

Joomla. How to change database tables prefix in SQL file

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

Joomla. How to change database tables prefix in SQL file, 2.5 out of 5 based on 2 ratings