How to change/replace database tables prefix ?

I this article, I would like to explain how to change/replace database all tables prefix. it is very simple so please just follow below steps and you can change all tables prefix of any database.

 

Step 1 : Please login into your phpmyadmin, After login into your phpmyadmin, you will find list of database in left sidebar. please select database in which you want to change/replace tables prefix. please see below screenshot :

Database Prefix

 

Step 2 : After select database you will show list of all tables of selected database. Please see below screenshot:

Database Prefix

 

Step 3 : Now please select tables which you want to change/replace prefix. please see below screenshot :

Database Prefix

Step 4 : Now Please select “Replace table prefix” Option from action drop-down list.

Database Prefix

Step 5 : After selecting option you will see Replace table prefix form with two input fields(From and To), In From box you need to enter previous prefix which you want to change and in “To” box you need to enter new prefix value and click on “Submit” button. please see screenshot :

Database Preifx

Step 6 : After this you will find updated prefix of tables. again select your database from left sidebar and see updated prefix.

Database Prefix