{"id":1141,"date":"2025-12-22T09:53:52","date_gmt":"2025-12-22T08:53:52","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=1141"},"modified":"2026-05-21T00:00:17","modified_gmt":"2026-05-20T22:00:17","slug":"de-ce-dimensiunea-bazei-de-date-sql-este-diferita-dupa-exportarea-intr-un-fisier-decat-pe-server","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/why-is-the-size-of-the-sql-database-different-after-exporting-to-a-file-than-on-the-server\/","title":{"rendered":"De ce dimensiunea bazei de date SQL este diferit\u0103 dup\u0103 exportarea \u00eentr-un fi\u0219ier dec\u00e2t pe server?"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">Atunci c\u00e2nd administra\u021bi un site web sau o aplica\u021bie pe <strong>mybox<\/strong>, desc\u0103rcarea unei copii de siguran\u021b\u0103 a bazei de date scoate adesea la iveal\u0103 o ciud\u0103\u021benie tehnic\u0103 care poate crea confuzie: <strong>fi\u0219ierul <code>.sql<\/code> desc\u0103rcat este semnificativ mai mic dec\u00e2t dimensiunea bazei de date afi\u0219at\u0103 \u00een panoul de g\u0103zduire<\/strong>, chiar dac\u0103 nu l-a\u021bi comprimat \u00eentr-un fi\u0219ier <code>.zip<\/code> sau <code>.gz<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceast\u0103 diferen\u021b\u0103 este absolut normal\u0103 \u0219i reprezint\u0103 o realitate opera\u021bional\u0103 fundamental\u0103 legat\u0103 de modul \u00een care sistemele de gestionare a bazelor de date rela\u021bionale (RDBMS), precum MySQL sau MariaDB, stocheaz\u0103 datele \u00een timp real pe un server, comparativ cu modul \u00een care le reprezint\u0103 \u00eentr-un fi\u0219ier.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Cuprins<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/de-ce-dimensiunea-bazei-de-date-SQL-este-diferit\u0103-dup\u0103-exportarea-\u00eentr-un-fi\u0219ier-fa\u021b\u0103-de-cea-de-pe-server\/#1_Spa\u021biu-suplimentar_\u0219i_spa\u021biu-liber-alocat_spa\u021biu-neutilizat_slack_space\">1. Spa\u021biu de rezerv\u0103 \u0219i spa\u021biu liber alocat (spa\u021biu neutilizat)<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/de-ce-dimensiunea-bazei-de-date-SQL-este-diferit\u0103-dup\u0103-exportarea-\u00eentr-un-fi\u0219ier-fa\u021b\u0103-de-cea-de-pe-server\/#2_Reprezentare_binar\u0103_vs_text_simplu\">2. Reprezentare binar\u0103 vs. text simplu<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/de-ce-dimensiunea-bazei-de-date-SQL-este-diferit\u0103-dup\u0103-exportarea-\u00eentr-un-fi\u0219ier-fa\u021b\u0103-de-cea-de-pe-server\/#3_Indicii_sunt_contura\u021bi_nu_stoca\u021bi\">3. Indicii sunt contura\u021bi, nu stoca\u021bi<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/de-ce-dimensiunea-bazei-de-date-SQL-este-diferit\u0103-dup\u0103-exportarea-\u00eentr-un-fi\u0219ier-fa\u021b\u0103-de-cea-de-pe-server\/#Matrix_de_comparare\">Matrix de comparare<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Overhead_and_Allocated_Free_Space_Unused_Slack_Space\"><\/span>1. Spa\u021biu de rezerv\u0103 \u0219i spa\u021biu liber alocat (spa\u021biu liber neutilizat)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<\/div>\n\n<div id=\"mybox-4181605909\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Bazele de date active sunt concepute pentru vitez\u0103, ceea ce \u00eenseamn\u0103 c\u0103 acord\u0103 prioritate introducerii rapide a datelor \u00een detrimentul economisirii stricte a spa\u021biului.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Realitatea serverului:<\/strong> C\u00e2nd datele sunt \u0219terse sau modificate pe serverul dvs. <strong>mybox<\/strong>, sistemul de baze de date nu mic\u0219oreaz\u0103 instantaneu fi\u0219ierul fizic de pe disc (acest lucru consum\u0103 foarte multe resurse). \u00cen schimb, las\u0103 acei sectoare goale, cre\u00e2nd \u201cg\u0103uri\u201d sau spa\u021biu liber nealocat, marcat pentru opera\u021biuni viitoare de scriere.<\/li>\n\n\n\n<li><strong>Realitatea exportului:<\/strong> C\u00e2nd declan\u0219a\u021bi un export (o copiere a bazei de date), sistemul cite\u0219te doar r\u00e2ndurile de date <em>active<\/em>. Spa\u021biile goale, prealocate, \u0219i suprasarcina intern\u0103 sunt eliminate, reduc\u00e2nd instantaneu dimensiunea fi\u0219ierului.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Binary_vs_Plain_Text_Representation\"><\/span>2. Reprezentarea binar\u0103 vs. reprezentarea \u00een text simplu<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Formatul unei baze de date active este radical diferit de cel al unui script de rezerv\u0103.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Stocare binar\u0103 (pe server):<\/strong> Pe serverul dvs., datele sunt scrise \u00eentr-un format binar extrem de complex (cum ar fi fi\u0219ierele InnoDB <code>.ibd<\/code>). Acesta include structura paginilor, spa\u021biile de tabel ale sistemului, ID-urile de urm\u0103rire a r\u00e2ndurilor \u0219i jurnalele de tranzac\u021bii.<\/li>\n\n\n\n<li><strong>Script text (fi\u0219ier exportat):<\/strong> Un fi\u0219ier <code>.sql<\/code> este doar un fi\u0219ier text simplu, plat. Acesta con\u021bine comenzi sub form\u0103 de \u0219iruri de caractere lizibile de c\u0103tre om, precum <code>CREATE TABLE<\/code> \u0219i <code>INSERT INTO<\/code>. Acesta elimin\u0103 complet \u00eenveli\u0219urile binare grele de stocare.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Indices_are_Outlined_Not_Stored\"><\/span>3. Indexurile sunt structurate, nu stocate<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Indexurile sunt o necesitate tehnic\u0103 pentru men\u021binerea vitezei interog\u0103rilor de c\u0103utare, dar ocup\u0103 mult spa\u021biu.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pe server:<\/strong> Indexurile sunt arbori binari brute, complet compila\u021bi, stoca\u021bi \u00een cache pe disc pentru a indica unde se afl\u0103 datele. \u00cen cazul tabelelor complexe ale aplica\u021biilor, <strong>indexurile pot ocupa cu u\u0219urin\u021b\u0103 30\u201350% din spa\u021biul total al serverului<\/strong>.<\/li>\n\n\n\n<li><strong>\u00cen fi\u0219ierul exportat:<\/strong> Instrumentul de export nu salveaz\u0103 harta structural\u0103 a indexului. \u00cen schimb, scrie o singur\u0103 linie de text care detaliaz\u0103 modul de reconstruire a acestuia: SQL<code>ALTER TABLE `wp_posts` ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`); <\/code>C\u00e2nd ve\u021bi importa \u00een cele din urm\u0103 acest fi\u0219ier \u00eentr-o nou\u0103 baz\u0103 de date, serverul va citi acea singur\u0103 linie de instruc\u021biuni \u0219i va construi indexurile voluminoase de la zero.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Comparison_Matrix\"><\/span>Matrice de compara\u021bie<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Component\u0103 tehnic\u0103<\/strong><\/td><td><strong>Inclus\u0103 pe serverul live?<\/strong><\/td><td><strong>Inclus \u00een exportul brut .sql?<\/strong><\/td><\/tr><\/thead><tbody><tr><td><strong>Date efective ale r\u00e2ndurilor<\/strong><\/td><td>Da (format binar)<\/td><td>Da (Format text simplu)<\/td><\/tr><tr><td><strong>Jurnale temporare\/de tranzac\u021bii<\/strong><\/td><td>Da (Salveaz\u0103 st\u0103rile \u00een caz de bloc\u0103ri)<\/td><td>Nu (Omise complet)<\/td><\/tr><tr><td><strong>Blocuri de r\u00e2nduri neutilizate\/\u0219terse<\/strong><\/td><td>Da (p\u0103strate ca tampoane de spa\u021biu liber)<\/td><td>Nu (omise \u00een totalitate)<\/td><\/tr><tr><td><strong>Indexuri compilate<\/strong><\/td><td>Da (Arbori de c\u0103utare complexi)<\/td><td>Nu (Salvate doar ca regul\u0103 de recreare)<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[388,389,390,391,392,393,394,395,396,397],"class_list":["post-1141","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-database-export","manual_kb_tag-database-backup","manual_kb_tag-database-dump","manual_kb_tag-export-file-size","manual_kb_tag-database-size","manual_kb_tag-file-structure","manual_kb_tag-metadata-impact","manual_kb_tag-transaction-logs","manual_kb_tag-temporary-tables","manual_kb_tag-index-size"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/1141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/1141\/revisions"}],"predecessor-version":[{"id":8341,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/1141\/revisions\/8341"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=1141"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=1141"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=1141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}