How to change a database table name
by Sapphire (January 23, 2008)
One of my Wordpress plugins stopped working when I upgraded. I figured out it was because the database tables had the version number for the plugin in them, so the new version was looking for the new version number. I could’ve done a fresh install and lost all my info… or I could just change the table name.
There’s no obvious way to do this in PhpMyAdmin. I had expected an edit icon that would let me change the table name, but I guess that would be too simple. I did some digging and found the answer:
Select the database that contains the table you want to edit. Then click on the “SQL” tab at the top of the page and run this query
RENAME TABLE tbl_name TO new_tbl_name
Not quite as simple as having buttons to click and forms to fill out and submit, but simple enough.
Posted in Tools
Subscribe to the feed or email updates
