{"id":20359,"date":"2026-11-22T08:47:02","date_gmt":"2026-11-22T05:47:02","guid":{"rendered":"https:\/\/www.hyyat.com\/knowledgebase\/cpanel-database-size-shows-zero\/"},"modified":"2026-11-22T08:47:17","modified_gmt":"2026-11-22T05:47:17","password":"","slug":"cpanel-database-size-shows-zero","status":"publish","type":"docs","link":"https:\/\/www.hyyat.com\/en\/knowledgebase\/cpanel-database-size-shows-zero\/","title":{"rendered":"Database Size Shows 0 MB in cPanel? The Fix in WHM or SSH"},"content":{"rendered":"<div class=\"hkb\" dir=\"ltr\">\n<div class=\"hkb-tldr\"><b>In short<\/b>If databases show <b>0 MB<\/b> in cPanel, the server is not counting them in disk usage. Turn it on in <b>WHM, Server Configuration, Tweak Settings<\/b>, the <b>SQL<\/b> tab, <b>Include databases in disk usage calculations<\/b>: On, then save. Or over SSH, set <code>disk_usage_include_sqldbs=1<\/code> and update the cache.<\/div>\n<figure class=\"hkb-fig\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2026\/11\/hkb-tr-13408-en.webp\" alt=\"Database Size Shows 0 MB in cPanel? The Fix in WHM or SSH\" width=\"1200\" height=\"630\" loading=\"lazy\" \/><\/figure>\n<div class=\"hkb-note\"><b>This guide is for server owners<\/b> if you have a VPS or dedicated server with WHM. If you would rather not manage the server yourself, our <a href=\"https:\/\/www.hyyat.com\/en\/server-management\/\">server management<\/a> service can do it for you.<\/div>\n<figure class=\"hkb-fig hkb-shot\"><img decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2019\/04\/Size-of-MySQL0.png\" alt=\"Database size showing 0 MB in cPanel\" loading=\"lazy\" \/><\/figure>\n<p>Sometimes databases show 0 MB in cPanel even though they hold data. The server is simply not counting databases in account disk usage. That makes usage figures inaccurate; turning the option on gives you and your customers real numbers.<\/p>\n<h2>The fix in WHM<\/h2>\n<ol class=\"hkb-steps\">\n<li><b>Log in to WHM<\/b> in your browser at <code>https:\/\/server-IP:2087<\/code> or <code>https:\/\/server-hostname:2087<\/code> as root.<\/li>\n<li><b>Open Server Configuration,<\/b> then <b>Tweak Settings<\/b>.<\/li>\n<li><b>Choose the SQL tab<\/b> and find <b>Include databases in disk usage calculations<\/b>.<\/li>\n<li><b>Set it to On<\/b> and click <b>Save<\/b>.<\/li>\n<\/ol>\n<figure class=\"hkb-fig hkb-shot\"><img decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2019\/02\/1_whm_firewall.png\" alt=\"Logging in to WHM\" loading=\"lazy\" \/><\/figure>\n<figure class=\"hkb-fig hkb-shot\"><img decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2019\/04\/Size-of-MySQL0-1.png\" alt=\"Server Configuration in WHM\" loading=\"lazy\" \/><\/figure>\n<figure class=\"hkb-fig hkb-shot\"><img decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2019\/04\/Size-of-MySQL0-2.png\" alt=\"The Tweak Settings page in WHM\" loading=\"lazy\" \/><\/figure>\n<figure class=\"hkb-fig hkb-shot\"><img decoding=\"async\" src=\"https:\/\/www.hyyat.com\/zasogooh\/2019\/04\/Size-of-MySQL0-3.png\" alt=\"The Include databases in disk usage calculations option in the SQL tab\" loading=\"lazy\" \/><\/figure>\n<h2>The fix from the command line<\/h2>\n<p>Log in over SSH as root, then run:<\/p>\n<pre class=\"hkb-code\">sed -i &#x27;s\/^disk_usage_include_sqldbs=.*\/disk_usage_include_sqldbs=1\/&#x27; \/var\/cpanel\/cpanel.config\n\/usr\/local\/cpanel\/scripts\/update_db_cache<\/pre>\n<div class=\"hkb-note\"><b>Careful:<\/b> after enabling it, displayed usage may rise for some accounts, and some may hit their plan limit. Review large accounts first.<\/div>\n<div class=\"hkb-hh\">\n<h2>Summary<\/h2>\n<ul>\n<li>The cause is an option turned off in Tweak Settings.<\/li>\n<li>Turn on Include databases in disk usage calculations.<\/li>\n<li>Update the cache if you change it over SSH.<\/li>\n<\/ul>\n<p style=\"margin:10px 0 0\">Need a server with cPanel and WHM? See <a href=\"https:\/\/www.hyyat.com\/en\/vps-hosting\/\">VPS servers<\/a> and <a href=\"https:\/\/www.hyyat.com\/en\/knowledgebase\/cpanel-whm-on-vps\/\">the cPanel and WHM on VPS guide<\/a>.<\/p>\n<\/div>\n<h2>Frequently asked questions<\/h2>\n<div class=\"hkb-faq\">\n<details>\n<summary>Why does my database size show zero in cPanel?<\/summary>\n<p>Because the server does not count databases in account disk usage. Turn the option on in Tweak Settings.<\/p>\n<\/details>\n<details>\n<summary>Does enabling it affect websites?<\/summary>\n<p>It changes nothing on the sites, but displayed usage may rise and some accounts may reach their limit.<\/p>\n<\/details>\n<\/div>\n<div class=\"hkb-rel\"><b>Related guides<\/b><\/p>\n<ul>\n<li><a href=\"https:\/\/www.hyyat.com\/en\/knowledgebase\/cpanel-whm-on-vps\/\">cPanel and WHM on a VPS \u2014 The Complete 2026 Guide: What They Are, Licensing, and When to Choose Them<\/a><\/li>\n<li><a href=\"https:\/\/www.hyyat.com\/en\/knowledgebase\/install-cpanel-whm\/\">How to Install cPanel and WHM on Your Server<\/a><\/li>\n<li><a href=\"https:\/\/www.hyyat.com\/en\/knowledgebase\/enable-autossl-whm\/\">How to Enable AutoSSL in WHM for Free Automatic SSL<\/a><\/li>\n<li><a href=\"https:\/\/www.hyyat.com\/en\/knowledgebase\/increase-phpmyadmin-upload-size-whm\/\">How to Increase the phpMyAdmin Upload Size on a cPanel Server<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.hyyat.com\/en\/kb\/whm-cpanel-control-panels\/\">All guides in this section \u2192<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In shortIf databases show 0 MB in cPanel, the server is not counting them in disk usage. Turn it on in WHM, Server Configuration, Tweak Settings, the SQL tab, Include databases in disk usage calculations: On, then save. Or over SSH, set disk_usage_include_sqldbs=1 and update the cache. This guide is for server owners if you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":20332,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_templately_pack_id":"","_templately_imported_at":"","_templately_source":"","_templately_import_session_id":"","footnotes":""},"doc_category":[2734],"doc_tag":[],"class_list":["post-20359","docs","type-docs","status-publish","has-post-thumbnail","hentry","doc_category-whm-cpanel-control-panels"],"year_month":"2026-11","word_count":369,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"admin","author_nicename":"admin","author_url":"https:\/\/www.hyyat.com\/en\/author\/admin\/"},"doc_category_info":[{"term_name":"WHM\/cPanel","term_url":"https:\/\/www.hyyat.com\/en\/kb\/whm-cpanel-control-panels\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/20359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/comments?post=20359"}],"version-history":[{"count":0,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/20359\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media\/20332"}],"wp:attachment":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media?parent=20359"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_category?post=20359"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_tag?post=20359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}