{"id":999,"date":"2021-07-23T12:43:07","date_gmt":"2021-07-23T12:43:07","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/manage-databases\/"},"modified":"2021-07-23T12:43:07","modified_gmt":"2021-07-23T12:43:07","slug":"manage-databases","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/manage-databases\/","title":{"rendered":"Manage Databases"},"content":{"rendered":"<\/p>\n
\n
\n
\n

Valid for versions 82 through the latest version<\/em><\/p>\n<\/div>\n

\n

Version:<\/h4>\n

82<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to list cPanel-managed databases on your server, each database\u2019s engine, and which user owns each database. You can also use this interface to rename databases.<\/p>\n

\n
Warning:<\/div>\n
\n
    \n
  • The maximum length of the database name is 64 characters. However, due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two<\/strong> characters of that limit. Therefore, if you enable database prefixing, the maximum length of the database name is 63 characters<\/strong>, which includes both the database prefix and the underscore character. Each additional underscore requires another two<\/strong> characters of that limit.<\/li>\n
  • It is potentially dangerous to rename a MySQL\u00ae database. We strongly<\/strong> recommend that you create a backup of a MySQL database that you wish to rename.<\/li>\n
  • If you rename a database, the process terminates all active connections to the database.<\/li>\n
  • You must<\/strong> manually update configuration files and applications to use the new database name.<\/li>\n
  • Larger and more complex databases requires additional time to rename.<\/li>\n<\/ul><\/div>\n<\/div>\n

    Databases<\/h2>\n

    This interface provides a table that lists all of the databases on the server.<\/p>\n

    Click each column heading to sort the list by that column. Search for a particular database with the Search<\/em> text box.<\/p>\n

    Rename a database<\/h3>\n

    To rename a database, perform the following steps:<\/p>\n

      \n
    1. Click the pencil icon in the row that corresponds to the database.<\/li>\n
    2. \n

      In the Rename<\/em> to text box, enter the new name for the database. <\/p>\n

      \n
      Warning:<\/div>\n
      \n If database prefixing is enabled, this parameter must<\/strong> include the database prefix for the account.\n <\/div>\n<\/div>\n<\/li>\n
    3. \n

      Click Submit<\/em>.<\/p>\n<\/li>\n<\/ol>\n

      How cPanel & WHM renames a MySQL database<\/h4>\n

      MySQL does not<\/strong> allow you to rename a database. When cPanel & WHM \u201crenames\u201d a database, the system performs the following steps:<\/p>\n

        \n
      1. The system creates a new database.<\/li>\n
      2. The system moves data from the old database to the new database.<\/li>\n
      3. The system recreates grants and stored code in the new database.<\/li>\n
      4. The system deletes the old database and its grants.<\/li>\n<\/ol>\n
        \n
        Warning:<\/div>\n
        \n
          \n
        • If any of the first three steps fail, the system returns an error and attempts to restore the database\u2019s original state. If the restoration process fails, the API function\u2019s error response describes these additional failures.<\/li>\n
        • In rare cases, the system creates the second database successfully, but fails to delete the old database or grants. The system treats the rename action as a success; however, the API function returns warnings that describe the failure to delete the old database or grants.<\/li>\n<\/ul><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

          Valid for versions 82 through the latest version Version: 82 Overview This interface allows you to list cPanel-managed databases on your server, each database\u2019s engine, and which user owns each database. You can also use this interface to rename databases. Warning: The maximum length of the database name is 64 characters. However, due to the …<\/p>\n","protected":false},"author":1,"featured_media":1000,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/999"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=999"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/999\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/1000"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}