Casbay Knowledge Base

Search our articles or browse by category below

HOW TO: Rename a table in phpMyAdmin

Last updated: September 7, 2022
Estimated reading time: 2 min

HOW TO: Rename a table in phpMyAdmin

It’s very easy to rename a table in phpMyAdmin. To do so, simply follow these steps:

  1. Firstly, log in to cPanel.
  2. From the Databases section, click on the phpMyAdmin icon.
  3. In the narrow left column, select the database containing the table you wish to rename. The screen will refresh with all of the tables found in that database.
  4. Then, click on the table you wish to rename; the screen will refresh with the selected tables’ information.
  5. After that, click on the Operations tab found on the top right; the screen will refresh again.
  6. In the Table options group, type a new name for the table in the Rename table to field.
  7. Lastly, click the Go button in the lower right and the table will be renamed.

Database Operations

First, open the phpMyAdmin tool, then go to the Databases tab. Select a database and navigate to the Operations tab. A new page opens on which you can find all the possible operations which you can use on a database.

The first section is Create table. It allows you to create a new table under the current database. Enter the table name and the number of the fields. Then click on Go to start the creation of the new table. 

The second section is Rename database to. Renaming a database cannot be performed directly through the phpMyAdmin area due to lack of privileges for the user. If you want to rename the database, you should create a new MySQL databaseexport the database tables and import them in the new one. Then you should delete the old database.

The same is the case with the Copy database to section. The difference with the above one is that you should not delete the source database.

The last section allows you to change the database Collation. Pick the preferred one from the drop-down menu and confirm the modification by clicking on Go.

Database Table Operations

To perform the corresponding operations on a database table, you should select the desired table in phpMyAdmin and click on the Operations tab.

The Move table to section allows you to move the table with a new name under the current database or to move it under a different database.

In the Table options section, you can rename the table, insert comments, change the storage engine and the collation.

Using the Copy table to section you can copy the table with a new name under the current database or it can be duplicated in another database.

Under the Table Maintenance section you will find different options which will help you to maintain your database table:

  • Analyze table – analyses and stores the key distribution for the table. Then the MySQL server uses the stored key distribution for JOIN operations and for decisions which index to be used in a table query;
  • Check table – checks the table and the views associated with it for errors and problems;
  • Repair table – repairs a possibly corrupted table;
  • Optimize table – the action should be performed when you delete or modify many records from the table. It will reclaim the used space, defragment the data file removing the overhead and sort the indexes. 
Was this article helpful?
Dislike 0
Discover the perfect balance of performance and budget-friendly Dedicated Server plan !
Discover the perfect balance of performance and budget-friendly Dedicated Server plan !
High performance and low cost Dedicated Server plan 128GB from $185 – upgrade today!
High performance and cheap Dedicated Server plan 128GB from $185 – upgrade today!