How to change a database table name
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.
Related posts:- Optimize your database!
- How to merge blogs together
- Speeding up older WordPress blogs
- Automatically updating your Wordpress install
- Preventing MySQL Database Crashes
Categories: Tools | 
Tags: | 
2 Comments »
February 16th, 2009 at 10:38 pm
I really liked your blog! You have some great content. Check out my blog and give me some feedback… I just posted a great blog about the 36 Best Wordpress plugins for 2009., thanks !
March 16th, 2009 at 12:32 am
Nice post, always. I’ve been online trying to make money now for about 6 months and your blog is one of the best i’ve come across. Always great content.