How to change database table prefix in SQL file

This article shows how to change database table prefix in the SQL file.
  1. Open the dump.sql file from “sources” (make sure to unzip archived folder first) folder with any text editor. You can use NotePad++, Dreamweaver or Sublime Text.

  2. Do a Find and replace (usually with the CTRL+H hotkeys) and change all the instances of default jos_ prefix to your custom database tables prefix. You can check for your own prefix in Joomla admin panel at the System -> Global Configuration -> Server -> Database Settings section, look for the Database Tables Prefix option value.
  3. When done editing, save the changes and import the modified SQL file into your Joomla database, you can find out database name under Database Settings section mentioned above.

Was this helpful?