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 13,197 views bookmark tags: databases mysql phpmyadmin (updated 10 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 828 days ago)
Knowledgebase Article 34,416 views tags: Plesk cpanel databases mysql phpmyadmin

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

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

Related Help Content

A guide to duplicating a MySQL database using phpMyAdmin (updated 828 days ago)
Knowledgebase Article 28,834 views tags: databases mysql phpmyadmin

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

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 827 days ago)
Knowledgebase Article 13,634 views tags: mysql phpmyadmin

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

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

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

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

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