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 14,718 views bookmark tags: databases mysql phpmyadmin (updated 81 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 899 days ago)
Knowledgebase Article 37,368 views tags: Plesk cpanel databases mysql phpmyadmin

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

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

Related Help Content

A guide to duplicating a MySQL database using phpMyAdmin (updated 899 days ago)
Knowledgebase Article 30,683 views tags: databases mysql phpmyadmin

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

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

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

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

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

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

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