How to change a database table prefix in PhpMyAdmin?

Here, to Change the database table prefix from previous to new one, OR add table_prefix to the tables.

How to change e database table prefix:

  1. First Log In to PhpMyAdmin.
  2. Now, Select the Database want to change.
  3. Click on the Structure and here all tables are listed.
  4. Now, in the bottom position, mark check all or Select the tables want to update or modify.
  5. A Modal will Pop Up, here fill the fields.
  6. In Modal: From : Enter Old table prefix
  7. In Modal: To: Enter new table prefix
  8. In Modal: Click Continue.
  9. Now all done. Check your tables.

Leave a Comment