How do I rename a table in phpMyAdmin?

Here is a step-by-step for renaming a table:

1. Log into cPanel

2. Click on "MySQL Databases"

3. On the page that loads, click on the "phpMyAdmin" link at the bottom. This should load a new window.

4. In this new window, select the DB that contains the table you want to modify from the drop down menu at the left (in the darker blue).

5. The screen should refresh with all of the tables in that DB. On the table you want to modify, click the Properties button, which is in the "Action" column, and it's the 4th icon from the left (little blue hand with a piece of paper).

6. At the top of the page now click the blue "Operations" link.

7. On the page that loads, the second item should be "rename table to." Enter the new name and hit "Go" This should rename your table.

  • 0 משתמשים שמצאו מאמר זה מועיל
?האם התשובה שקיבלתם הייתה מועילה

מאמרים קשורים

Can I backup my MySQL database? How do I backup my database?

You can backup your database two ways. 1. Click on Backup in Cpanel then click on the database...

What is the number of maximum connections allowed to a single MySQL database?

We allow up to 50 simultaneous connections per MySQL user, and up to 1500 simultaneous...

Can I use MySQL Front to access my database?

You can remotely connect to your database by using your domain name as the host you are...

How do I export and import a mysql db using PHPMyAdmin?

Step 1: Open phpMyAdmin and select the database from where you want to export data and/or...

Does your MySQL server support extended character sets, foreign character sets, and collation sets?

In the control panel's left-hand side of the page, there should be a MySQL version for your...