{"id":66,"date":"2010-04-14T14:28:33","date_gmt":"2010-04-14T19:28:33","guid":{"rendered":"http:\/\/blogs.wp.stage.cpanel.net\/2010\/04\/a_general_overview_of_database_mapping\/"},"modified":"2010-04-14T14:28:33","modified_gmt":"2010-04-14T19:28:33","slug":"a_general_overview_of_database_mapping","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/","title":{"rendered":"A General Overview of Database Mapping"},"content":{"rendered":"

Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username.<\/p>\n

The benefit of the DB Mapping feature is that when transferring accounts from non-cpanel systems, the database name will now be preserved rather than having to hunt it down in configuration files and waste extra time on account migrations. \u00a0The other benefit is that users will not longer have the confusion of having their username automatically prefixed to the database name. \u00a0When they create a database it will be the string that they type into cPanel.<\/p>\n

The core DB Mapping functionality has been factored into the cPanel code, however the new behavior is not exposed in the cPanel interface until you enable it, i.e. \u2018opt-in.\u2019 \u00a0This design provides two key benefits. 1) If you\u2019re migrating from \u00a0a non-cPanel system the database names will stay perfectly intact and 2) It eases the transition from the old, username prefixes, to the new non-prefix database names; you can chose when the best time is to offer this functionality and it\u2019s just a click away.<\/p>\n

To enable DB Mapping and remove the prefix behavior, a Tweak Settings toggle as been added. \u00a0Enabling ones cPanel system will have no effect on pre-existing databases. \u00a0CPanel interfaces and database creation will still continue to function as it has until you \u2018opt-in\u2019 from this Tweak Setting.<\/p>\n

The affect of this on themes and integrated applications is that there will be the addition of new API calls to handle the new system of managing databases. \u00a0Some backwards compatibility may be broken in the move to the new system, so please beware!<\/p>\n

We will have a blog post detailing the technical details of this system around the same time that we release 11.25.1 to EDGE.<\/p>\n","protected":false},"excerpt":{"rendered":"

Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username. The benefit […]<\/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":[],"class_list":["post-66","post","type-post","status-publish","format-standard","hentry","category-products"],"acf":[],"yoast_head":"\nA General Overview of Database Mapping | cPanel<\/title>\n <!-- Mirrored from cpanel.net/wp-json/wp/v2/posts/66/ by HTTrack Website Copier/3.x [XR&CO'2014], Fri, 06 Sep 2024 09:40:52 GMT --> <meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=_-1456.html \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A General Overview of Database Mapping | cPanel\" \/>\n<meta property=\"og:description\" content=\"Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username. The benefit […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/\" \/>\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=\"2010-04-14T19:28:33+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=\"2 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\/a_general_overview_of_database_mapping\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/\",\"name\":\"A General Overview of Database Mapping | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2010-04-14T19:28:33+00:00\",\"dateModified\":\"2010-04-14T19:28:33+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A General Overview of Database Mapping\"}]},{\"@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 & 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":"A General Overview of Database Mapping | 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\/a_general_overview_of_database_mapping\/","og_locale":"en_US","og_type":"article","og_title":"A General Overview of Database Mapping | cPanel","og_description":"Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username. The benefit […]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2010-04-14T19:28:33+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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/","url":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/","name":"A General Overview of Database Mapping | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2010-04-14T19:28:33+00:00","dateModified":"2010-04-14T19:28:33+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"A General Overview of Database Mapping"}]},{"@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 & 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\/66"}],"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=66"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/66\/revisions"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}