By testreview0
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
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!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.