HostMonster Web Hosting Help

How to rename database tables in phpMyAdmin

Due to limitations in PHP MyAdmin you cannot rename a database table. You must take a different approach. The following steps will explain a work around by making a copy of the table instead.

  1. Create a new database table with the new name.
  2. Export the old database table.
  3. Now import the old database into the new database.
Knowledgebase Article 15,712 views bookmark tags: databases mysql phpmyadmin (updated 140 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

Instructions on deleting tables from your database using phpMyAdmin (updated 958 days ago)
Knowledgebase Article 38,608 views tags: Plesk cpanel databases mysql phpmyadmin

Instructions on changing the name of your database using phpMyAdmin (updated 958 days ago)
Knowledgebase Article 36,467 views tags: cpanel databases mysql phpmyadmin

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin (updated 958 days ago)
Knowledgebase Article 43,117 views tags: databases mysql phpmyadmin

Related Help Content

A guide to duplicating a MySQL database using phpMyAdmin (updated 958 days ago)
Knowledgebase Article 31,965 views tags: databases mysql phpmyadmin

This article will walk you through the steps to copying and renaming a database with phpMyAdmin. (updated 125 days ago)
Knowledgebase Article 18,256 views tags: database phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 957 days ago)
Knowledgebase Article 16,153 views tags: mysql phpmyadmin

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 958 days ago)
Knowledgebase Article 155,712 views tags: commands database mysql phpmyadmin

Step by step directions on how you can search your database using phpMyAdmin (updated 958 days ago)
Knowledgebase Article 13,987 views tags: Plesk cpanel databases mysql phpmyadmin

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 124 days ago)
Knowledgebase Article 169,279 views tags: database mysql phpmyadmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 956 days ago)
Knowledgebase Article 38,508 views tags: Plesk cpanel databases mysql phpmyadmin

How to repair and optimize your database using phpMyAdmin: (updated 1149 days ago)
Knowledgebase Article 191,571 views tags: database mysql optimizing repairing slow speed