Renaming Database Tables with PhpMyAdmin

Reading Time: 2 minutes

Renaming a table within a database is a task that may need to be done occasionally. You might just need to rename it for clarification purposes, to archive old data, to make a copy when a restore is being done, or any number of other reasons. PhpMyAdmin helps you rename a database quickly with just a few clicks.

This guide assumes that you have already logged in to PhpMyAdmin.We will go over how to rename a table and how to rename a database as well.

08-01-Main_Page

First from the main page in PhpMyAdmin, click on the database that the table we want to rename is in.

08-02-Table_Name

Then once the navigation expands, click on the table that should be renamed.

08-03-Table_Operations

On the table’s page, go to the Operations tab, which might be under the More option if the screen isn’t wide enough.

Under the “Table options” section, it shows “Rename table to” and has the current table’s name. We make the changes here and then click on the Go button to save the change.

08-04-Table_Rename

PhpMyAdmin then confirms that the table name has been changed and also displays the new name on the left navigation. 

08-05-Database_Name

To rename a database, the actions are similar, click on the database name we want to change.

Go to the Operations tab.

08-06-Database_Operations

Then look for the “Rename database to” section and we can change the database’s name in this box. Then click on the Go button first, then click OK on the pop up box to save the changes.

08-07-Database_Rename

Then the database name has been updated and is reflected on the left navigation!

08-08-New_Names

Conclusion

Renaming tables and databases within PhpMyAdmin is quick and easy to do if you know where to look. Rename with caution though as it could affect any queries that use those specific table names. 

Give us a call at 800.580.4985, or open a chat or ticket with us to speak with one of our knowledgeable Solutions or Experienced Hosting advisors to learn more about our Dedicated servers or our VPS servers and how you can take advantage of these deals today!

Series Navigation<< Previous ArticleNext Article >>

Author Bio

About the Author: Alex Gorzen

Alex Gorzen has been helping others with technology his whole life. He played with computers even before he could read and wants to make sure his children share that same love as they grow up. In his free time he enjoys gardening, building things, and learning new skills.

Refer a friend and get hosting credit!