25th Anniversary Savings | 25% Off Dedicated Servers*Shop Now
25th Anniversary Savings | 25% Off VPS Hosting* †††Shop Now
Limited Inventory: High-Performance AMD-Powered Servers Now Available.* Shop Now >
Dedicated Hosting Deals | From $99/moShop Now

Renaming Database Tables with PhpMyAdmin

Posted on by Alex Gorzen | Updated:
Reading Time: 3 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.

Renaming Database Tables with PhpMyAdmin

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.


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


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


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.


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


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

Go to the Operations tab.


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.


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



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 >>

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.

Latest Articles

What Is WebP and What Makes it Different from Other Image Formats?

Read Article

Top 10 Password Security Standards

Read Article

Top 10 Password Security Standards

Read Article

How to Install MongoDB on AlmaLinux

Read Article

How to Use the WP Toolkit to Secure and Update WordPress

Read Article