Rename DB Table Prefix does what it says on the tin.
| Author: | Jeff Gould (profile at wordpress.org) |
| WordPress version required: | 3.0.1 |
| WordPress version tested: | 4.8.2 |
| Plugin version: | 0.1.0 |
| Added to WordPress repository: | 29-09-2017 |
| Last updated: | 29-09-2017
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|
| Rating, %: | 96 |
| Rated by: | 6 |
| Plugin URI: | http://jrgould.com/rdtp/ |
| Total downloads: | 2 102 |
| Active installs: | 100+ |
Click to start download
|
Screenshots
Step 1 - confirm that you have backed up your database
Step 2 - confirm that you have backed up your wp-config.php
Step 3 - input your new table prefix or use the auto-generated one
Step 4 - db table prefix has been renamed successfully
Installation Instructions
- Upload
rdtp.php to the /wp-content/plugins/ directory
- Activate the plugin through the ‘Plugins’ menu in WordPress
- Find
Rename DB Table Prefix in the Tools menu
- Back up your database and
wp-config.php files before using Rename DB Table Prefix
Why would I need to rename my table prefix
Primarily for situations when you have dev or staging sites that have different table prefixes than your prod site. When running migrations with plugins like WP Migrate DB (Pro), or even manually, it’s usually necessary to have the source and destination site running on the same table prefix.
Also, some people think that changing your table prefix from wp_ to something else provides some security through obscurity. This probably isn’t very true.
What happens if something goes wrong
It is imperative that you make and test backups of your database and wp-config.php file before running RDTP. If something goes wrong and you find that your site is broken, you will need to restore your site from those backups.
The first thing RDTP does is try to change the $table_prefix variable in your wp-config.php file, and this is the most likely point that you will encounter an error. If RDTP is unable to update your wp-config.php file, it won’t continue on to update the database, so you’ll probably just need to check the permissions on your wp-config.php and try again.
ChangeLog
