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.

Related Posts:

About Craig Lotter

South African software architect and developer at Touchwork. Husband to a cupcake baker and father to two little girls. I don't have time for myself any more.