The purpose of this tutorial is to teach you how to rename mysql database tables with phpMyAdmin. We will assume that you are already logged in to phpMyAdmin. For this tutorial, we will use a database with one table for an example.
Let's learn how to rename MySQL database tables. The left side of the main screen of phpMyAdmin is where you will find your database listed, with the table listed below the database name. The right side, a big white screen is where the actions take place. To start, select the database table you wish to rename in the list on the left hand side window. Select the table by clicking on it. The phpMyAdmin window on the right hand side will open up with the details about the table you have selected. Now, at the top of the right hand screen, click on the Operations button. This will open a list of actions you can perform on the table you have selected.
Scroll down phpMyAdmin setup to the box titled "Table Options". The first line is Rename the MySQL table to with an empty box. Enter the new name for your table in this box. When you are done, click on the Go Button in the lower right corner. This will open the confirmation window, which shows that the table has been renamed. If you look in the phpMyAdmin setup panel on the left hand side, the table you selected is now showing the new name.
This is the end of this tutorial. You now know how to rename database tables using phpMyAdmin setup.
How to run SQL Queries on a database using phpmyadmin