{"id":16312,"date":"2014-02-05T19:38:38","date_gmt":"2014-02-06T01:38:38","guid":{"rendered":"http:\/\/blog.cpanel.net\/?p=16312"},"modified":"2014-02-05T19:38:38","modified_gmt":"2014-02-06T01:38:38","slug":"update-to-recent-database-prefixing-post","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/","title":{"rendered":"Update to Recent Database Prefixing Post"},"content":{"rendered":"<p>First, we would like to thank everyone who has provided us with feedback on our recent blog post about database name length restrictions and database prefixing.<\/p>\n<p>In response to the conversations that we have had, both online and offline, we have developed a new set of minimum delivery requirements for database users and names in cPanel &amp; WHM version 11.44.<\/p>\n<p><!--more--><br \/>\n<strong>Minimum Requirements Expansion<\/strong><\/p>\n<ol>\n<li>The setting to enforce prefixing restrictions on NEW database users and database names will be preserved. This setting will be converted from an interface in WHM (<em>Home &gt;&gt; SQL Services &gt;&gt; Disable Database Prefix<\/em>) to a tweak setting that can be enabled or disabled, and it will continue to be enabled by default.<\/li>\n<li>We will extend the maximum system account username length from 8 to 16 characters. However, the first 8 characters must be unique for NEW accounts in order to avoid prefix conflicts.<\/li>\n<li>We will allow database names and usernames to be transferred from remote systems that are NOT prefixed. We will ignore prefixing restrictions so changing users and database names will be unnecessary. This allows you to avoid changes to users&#8217; applications.<\/li>\n<li>If there is a conflict between database usernames or database names during a transfer, the express transfer feature will automatically be disabled for that account (if it was requested).<\/li>\n<\/ol>\n<p>These improvements to the restricted restore and transfer system are expected to increase delivery time by about four weeks. However, we may still be able to deliver the system with cPanel &amp; WHM version 11.44 if we delay the next phase of our SSL improvements project (Spring 2014 release).<\/p>\n<p><strong>Optional Feature &#8211; Database &amp; User Pre-Transfer Name Conflict Resolution Interface<\/strong><\/p>\n<p>Currently, the system appends a number to the database name (for example, database2, database3, etc.) to resolve the conflict.\u00a0This is a non-interactive process, and the only indication of a conflict will appear in the transfer log.<\/p>\n<p>In order to improve the visibility of this type of conflict, we could develop a new system that would allow administrators to specify new database usernames and database names when a pre-transfer conflict is detected.<\/p>\n<ul>\n<li>This system would download the database usernames and database names from the remote system before the transfer begins.<\/li>\n<li>A list of conflicting usernames and databases will display. The administrator will have the option to choose a new database name and username.<\/li>\n<\/ul>\n<p>These requirements for the restricted and transfer system are expected to increase the delivery time by approximately four weeks, in addition to the minimum requirements previously listed.\u00a0If these are required in order to ship the new system, then we expect the system to ship with cPanel &amp; WHM version 11.46. Also, this would push some of the features that are already scheduled to be included in cPanel &amp; WHM version 11.46 (Fall 2014 release) back to cPanel &amp; WHM version 11.48 (Winter Q1 2015 release).<\/p>\n<hr \/>\n<p>Please let us know if this new plan better balances your needs, and if you feel we need to include the name conflict resolution interface at the expense of delaying other features. It is our goal to offer a smoother transfer process while keeping system administration as easy as possible.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, we would like to thank everyone who has provided us with feedback on our recent blog post about database name length restrictions and database prefixing. In response to the conversations that we have had, both online and offline, we have developed a new set of minimum delivery requirements for database users and names in [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[49],"tags":[845,45],"class_list":["post-16312","post","type-post","status-publish","format-standard","hentry","category-products","tag-11-44","tag-proddevsec"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Update to Recent Database Prefixing Post | cPanel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Update to Recent Database Prefixing Post | cPanel\" \/>\n<meta property=\"og:description\" content=\"First, we would like to thank everyone who has provided us with feedback on our recent blog post about database name length restrictions and database prefixing. In response to the conversations that we have had, both online and offline, we have developed a new set of minimum delivery requirements for database users and names in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-06T01:38:38+00:00\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/\",\"name\":\"Update to Recent Database Prefixing Post | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2014-02-06T01:38:38+00:00\",\"dateModified\":\"2014-02-06T01:38:38+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Update to Recent Database Prefixing Post\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Update to Recent Database Prefixing Post | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/","og_locale":"en_US","og_type":"article","og_title":"Update to Recent Database Prefixing Post | cPanel","og_description":"First, we would like to thank everyone who has provided us with feedback on our recent blog post about database name length restrictions and database prefixing. In response to the conversations that we have had, both online and offline, we have developed a new set of minimum delivery requirements for database users and names in [&hellip;]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2014-02-06T01:38:38+00:00","author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/","url":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/","name":"Update to Recent Database Prefixing Post | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2014-02-06T01:38:38+00:00","dateModified":"2014-02-06T01:38:38+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/update-to-recent-database-prefixing-post\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"Update to Recent Database Prefixing Post"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/16312"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=16312"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/16312\/revisions"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=16312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=16312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=16312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}