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

October 13, 2016 50 views
DigitalOcean PHP

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:

1 Answer

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.

Have another answer? Share your knowledge.