{"id":75437,"date":"2017-09-29T16:30:52","date_gmt":"2017-09-29T16:30:52","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/rename-db-table-prefix\/"},"modified":"2017-09-29T16:30:52","modified_gmt":"2017-09-29T16:30:52","slug":"rename-db-table-prefix","status":"publish","type":"plugin","link":"https:\/\/fi.wordpress.org\/plugins\/rename-db-table-prefix\/","author":242142,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.1.0","stable_tag":"trunk","tested":"4.8.28","requires":"3.0.1","requires_php":"","requires_plugins":"","header_name":"Rename DB Table Prefix","header_author":"Jeff Gould","header_description":"Change the table prefix of your WordPress install.","assets_banners_color":"","last_updated":"2017-09-29 16:30:52","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"http:\/\/jrgould.com\/rdtp\/","header_author_uri":"http:\/\/jrgould.com\/","rating":4.8,"author_block_rating":0,"active_installs":100,"downloads":3176,"num_ratings":6,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":1,"5":5},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.1.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1738517","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1738517","resolution":"2","location":"assets"},"screenshot-3.jpg":{"filename":"screenshot-3.jpg","revision":"1738517","resolution":"3","location":"assets"},"screenshot-4.jpg":{"filename":"screenshot-4.jpg","revision":"1738517","resolution":"4","location":"assets"}},"screenshots":{"1":"Step 1 - confirm that you have backed up your database","2":"Step 2 - confirm that you have backed up your wp-config.php","3":"Step 3 - input your new table prefix or use the auto-generated one","4":"Step 4 - db table prefix has been renamed successfully"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[153,1627,16989,147165],"plugin_category":[59],"plugin_contributors":[77942,147166],"plugin_business_model":[],"class_list":["post-75437","plugin","type-plugin","status-publish","hentry","plugin_tags-database","plugin_tags-mysql","plugin_tags-prefix","plugin_tags-table_prefix","plugin_category-utilities-and-tools","plugin_contributors-deliciousbrains","plugin_contributors-jrgould","plugin_committers-jrgould"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/rename-db-table-prefix.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/rename-db-table-prefix\/assets\/screenshot-1.png?rev=1738517","caption":"Step 1 - confirm that you have backed up your database"},{"src":"https:\/\/ps.w.org\/rename-db-table-prefix\/assets\/screenshot-2.png?rev=1738517","caption":"Step 2 - confirm that you have backed up your wp-config.php"},{"src":"https:\/\/ps.w.org\/rename-db-table-prefix\/assets\/screenshot-3.jpg?rev=1738517","caption":"Step 3 - input your new table prefix or use the auto-generated one"},{"src":"https:\/\/ps.w.org\/rename-db-table-prefix\/assets\/screenshot-4.jpg?rev=1738517","caption":"Step 4 - db table prefix has been renamed successfully"}],"raw_content":"\n

Need to change your table prefix from wp_<\/code> to something else on a site that's already running? Not running a multisite install? Rename DB Table Prefix can probably help.<\/p>\n\n

RDTP's primary functionality is based on the great WP-CLI package, wp-cli-rename-db-prefix<\/a>.<\/p>\n\n

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<\/code> files from good backups if this happens.<\/p>\n\n\n

    \n
  1. Upload rdtp.php<\/code> to the \/wp-content\/plugins\/<\/code> directory<\/li>\n
  2. Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n
  3. Find Rename DB Table Prefix<\/code> in the Tools menu<\/li>\n
  4. Back up your database and wp-config.php<\/code> files before using Rename DB Table Prefix<\/li>\n<\/ol>\n\n\n
    \n
    Installation Instructions<\/dt>\n
      \n
    1. Upload rdtp.php<\/code> to the \/wp-content\/plugins\/<\/code> directory<\/li>\n
    2. Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n
    3. Find Rename DB Table Prefix<\/code> in the Tools menu<\/li>\n
    4. Back up your database and wp-config.php<\/code> files before using Rename DB Table Prefix<\/li>\n<\/ol><\/dd>\n
      Why would I need to rename my table prefix<\/dt>\n

      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.<\/p>\n\n

      Also, some people think that changing your table prefix from wp_<\/code> to something else provides some security through obscurity. This probably isn't very true.<\/p><\/dd>\n

      What happens if something goes wrong<\/dt>\n

      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.<\/p>\n\n

      The first thing RDTP does is try to change the $table_prefix<\/code> variable in your wp-config.php<\/code> file, and this is the most likely point that you will encounter an error. If RDTP is unable to update your wp-config.php<\/code> 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<\/code> and try again.<\/p><\/dd>\n\n<\/dl>\n\n\n

      0.1<\/h4>\n\n
        \n
      • Initial Release<\/li>\n<\/ul>","raw_excerpt":"Rename DB Table Prefix does what it says on the tin.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/75437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=75437"}],"author":[{"embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/jrgould"}],"wp:attachment":[{"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=75437"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=75437"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=75437"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=75437"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=75437"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/fi.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=75437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}