這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

Rename DB Table Prefix

描述

Need to change your table prefix from wp_ to something else on a site that’s already running? Not running a multisite install? Rename DB Table Prefix can probably help.

RDTP’s primary functionality is based on the great WP-CLI package, wp-cli-rename-db-prefix.

Use at your own risk and make backups before running this plugin – it is entirely possible that this could break your site and you will need to be able to restore your database and wp-config.php files from good backups if this happens.

螢幕截圖

  • 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

安裝

  1. Upload rdtp.php to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Find Rename DB Table Prefix in the Tools menu
  4. Back up your database and wp-config.php files before using Rename DB Table Prefix

常見問題

Installation Instructions
  1. Upload rdtp.php to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Find Rename DB Table Prefix in the Tools menu
  4. 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.

評價

2022年4月22日
It does what it says and it does well. The plugin asks you if you have baked up you database and wp-config.php file, which it is a good reminder 🙂 I wouldn't expect less from the authors. Thanks for your work!
2018年12月7日
I always make a point of changing the default wp_ prefix on new installs for better security and this one time I forgot. D'oh. I was about to do it manually using a text editor and phpMyAdmin and thought, 'gee, i wonder if there's a plugin that could make quick work of this'? I saw Delicious Brains associated with this plugin and since I use their awesome Better Search Replace plugin a fair bit, I decided to give it a whirl. Holy crap - what a huge time saver! One click and done (I ran backups first). I checked my wp-config file and the db and everything looks ship-shape. Awesome little plugin. Thanks for sharing! Highly recommended - but back up first! PK
2018年10月11日
Actually it did the job easily, great work
閱讀全部6個評價

貢獻者及開發者

“Rename DB Table Prefix” 是一個開源的軟體。以下的人對這個外掛作出了貢獻。

貢獻者

將 Rename DB Table Prefix 外掛本地化為台灣繁體中文版。

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

修改日誌

0.1

  • Initial Release