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,190 views bookmark tags: databases mysql phpmyadmin (updated 110 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 928 days ago)
Knowledgebase Article 37,924 views tags: Plesk cpanel databases mysql phpmyadmin

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

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

Related Help Content

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

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

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 927 days ago)
Knowledgebase Article 15,690 views tags: mysql phpmyadmin

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

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

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

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

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