Question

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

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.