Title: Rename DB Table Prefix Author: JRGould Published: 2017 年 9 月 29 日 Last modified: 2017 年 9 月 29 日 --- 搜索插件 **该插件尚未通过WordPress的最新3个主要版本进行测试**。 当与较新版本的WordPress一起 使用时，可能不再受到维护或支持，并且可能会存在兼容性问题。 ![](https://s.w.org/plugins/geopattern-icon/rename-db-table-prefix.svg) # Rename DB Table Prefix 作者：[JRGould](https://profiles.wordpress.org/jrgould/) [下载](https://downloads.wordpress.org/plugin/rename-db-table-prefix.zip) * [详情](https://cn.wordpress.org/plugins/rename-db-table-prefix/#description) * [评价](https://cn.wordpress.org/plugins/rename-db-table-prefix/#reviews) * [安装](https://cn.wordpress.org/plugins/rename-db-table-prefix/#installation) * [开发进展](https://cn.wordpress.org/plugins/rename-db-table-prefix/#developers) [支持](https://wordpress.org/support/plugin/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](https://github.com/iandunn/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. ## 评价 ![](https://secure.gravatar.com/avatar/3b917e1fb96d5284d83bf5985ddc4391c4b8ac3db9b0c41b6ad9839eeaf5dc55? s=60&d=retro&r=g) ### 󠀁[Supper easy to rename table prefix. 😀](https://wordpress.org/support/topic/supper-easy-to-rename-table-prefix-d/)󠁿 [Bluemad](https://profiles.wordpress.org/bluemad/) 2022 年 7 月 5 日 This plugin makes renaming the WordPress Database table prefixes hassle-free. ![](https://secure.gravatar.com/avatar/6b0b3d2ccb76ed2055e6057fae21b9c8637d273c280dc166e880c85e98d6856f? s=60&d=retro&r=g) ### 󠀁[Clean and fast](https://wordpress.org/support/topic/clean-and-fast-17/)󠁿 [Luis Colome](https://profiles.wordpress.org/luiscolome/) 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! ![](https://secure.gravatar.com/avatar/9900fc9f5da490e957ca38537fd69b1542bcfd98bcf42c7b54bb2f1ed609add5? s=60&d=retro&r=g) ### 󠀁[Does its job](https://wordpress.org/support/topic/do-its-job-2/)󠁿 [iamhoseyn](https://profiles.wordpress.org/iamhoseyn/) 2021 年 5 月 9 日 Good if your wp-config file is writable. ![](https://secure.gravatar.com/avatar/0d88e69cd5146d0a92994dbf3f629384454aa3c3a03cf59989acdfc672a5b258? s=60&d=retro&r=g) ### 󠀁[Excellent Plugin, Great Time Saver](https://wordpress.org/support/topic/excellent-plugin-great-time-saver/)󠁿 [Pat K](https://profiles.wordpress.org/blackcapdesign/) 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 ![](https://secure.gravatar.com/avatar/1a8a0207b259a9e291d94d9057d18b7a370d2984da2276381330bf00431538e6? s=60&d=retro&r=g) ### 󠀁[Awesome](https://wordpress.org/support/topic/awesome-6020/)󠁿 [Prosentra](https://profiles.wordpress.org/wpress_class/) 2018 年 10 月 11 日 Actually it did the job easily, great work ![](https://secure.gravatar.com/avatar/144a06add354148580348d88fbc635aa8688af129d96b5a177b2520ec05009c3? s=60&d=retro&r=g) ### 󠀁[Worked](https://wordpress.org/support/topic/worked-59/)󠁿 [Phi Phan](https://profiles.wordpress.org/mr2p/) 2018 年 4 月 26 日 Great work! Save time. [ 阅读所有6条评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/) ## 贡献者及开发者 「Rename DB Table Prefix」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ JRGould ](https://profiles.wordpress.org/jrgould/) * [ Delicious Brains ](https://profiles.wordpress.org/deliciousbrains/) [帮助将「Rename DB Table Prefix」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/rename-db-table-prefix) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/rename-db-table-prefix/)， 查看[SVN仓库](https://plugins.svn.wordpress.org/rename-db-table-prefix/)，或通过 [RSS](https://plugins.trac.wordpress.org/log/rename-db-table-prefix/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/rename-db-table-prefix/)。 ## 更新日志 #### 0.1 * Initial Release ## 额外信息 * 版本 **0.1.0** * 最后更新：**9 年前** * 活跃安装数量 **100+** * WordPress 版本 ** 3.0.1 或更高版本 ** * 已测试的最高版本为 **4.8.28** * 语言 * [English (US)](https://wordpress.org/plugins/rename-db-table-prefix/) * 标签 * [database](https://cn.wordpress.org/plugins/tags/database/)[mysql](https://cn.wordpress.org/plugins/tags/mysql/) [Prefix](https://cn.wordpress.org/plugins/tags/prefix/) * [高级视图](https://cn.wordpress.org/plugins/rename-db-table-prefix/advanced/) ## 评级 4.8 星（最高 5 星）。 * [ 5 条 5 星评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/?filter=5) * [ 1 条 4 星评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/?filter=2) * [ 0 条 1 星评价 ](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/rename-db-table-prefix/reviews/) ## 贡献者 * [ JRGould ](https://profiles.wordpress.org/jrgould/) * [ Delicious Brains ](https://profiles.wordpress.org/deliciousbrains/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/rename-db-table-prefix/)