I'm trying to rename the databse table in phpmyadmin but name can't be chnaged.

Hy I’m trying to rename the already created table in database but after changing the name when i click on save then its does not work same as if i try to copy, move or giving index to some columns instead of when i create new table rename it, move it, copy it or giving index to any column its work and allow me to do all in new created tables, so how can we rename previous or existing table in database and import new tables. Kind Regards: EVS


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Without details on what error you are seeing (if any) it’s hard to troubleshoot this but I do have one suggestion.

In PHPMyAdmin try doing the rename as a SQL query rather than using the GUI tools:

RENAME TABLE old_table TO new_table;

using your table names. If this query returns an error, share the error message here. Note that if you are not using the root account in PHPMyAdmin it is also possible that the user you are logged in as does not have the appropriate permissions to rename the table. The error message should indicate this if that’s the case.