How to Rename a Table using phpMyAdmin Software & Sites 27 APR 2012

It is not immediately apparent how you go about changing the name of a MySQL database table via the phpMyAdmin interface, so I thought I would drop a quick note here to remind me how to do it in the future.

To rename a table in phpMyAdmin, select the targeted table from the database table list in the left hand column.

You’ll see that the breadcrumb navigation will now indicate that you are in the desired tabled (server -> database -> table), and you will now have to click on the Operations tab (near the right hand side of the screen).

In the Table Options fieldset you will find a text box with the label reading “Rename table to”. Simply enter the new name that you wish to rename the table to, and hit the Go button at the bottom of the fieldset.

As easy as that.

About Craig Lotter

Software developer, husband and dad to two little girls. Writer behind An Exploring South African. I don't have time for myself any more.