{"id":935,"date":"2025-12-19T10:45:43","date_gmt":"2025-12-19T09:45:43","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=935"},"modified":"2026-02-04T13:23:24","modified_gmt":"2026-02-04T12:23:24","slug":"what-are-databases","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/","title":{"rendered":"What are databases?"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\"><strong>A database<\/strong> is a set of data stored in a strictly defined way in structures corresponding to the assumed data model. In common terms, it includes data and a computer program specialized in collecting and processing this data. Such a program (often a set of programs) is called a &#8220;Database Management System&#8221; (DBMS). In strict nomenclature, a database is a set of data that is managed by a <strong>DBMS.<\/strong><\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"473\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db-1024x473.png\" alt=\"\" class=\"wp-image-4053\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db-1024x473.png 1024w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db-300x138.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db-768x354.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db-18x8.png 18w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/mybox-db.png 1404w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\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\">Table of Contents<\/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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/#Database_backups\" >Database backups<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/#Database_access_parameters\" >Database access parameters<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/#Database_Management_Systems\" >Database Management Systems<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/#MySQL\" >MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/what-are-databases\/#SQLite\" >SQLite<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_backups\"><\/span>Database backups<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the new version of the mybox panel, you can restore the backup yourself. To do this, click on &#8220;Database&#8221; in the new the mybox panel and then on &#8220;Backups&#8221;. A menu will then expand that will allow us to download or restore a backup from a specific date.<\/p>\n\n\n\n<\/div>\n\n<div id=\"mybox-792005691\" 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\">Early access<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Still need help?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contact our customer service team.<\/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\">Message us<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">NOTE: In order to restore backups older than 5 days, please contact <strong><em>the &#8220;Customer Service&#8221;<\/em><\/strong> via the Helpdesk 24h.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_access_parameters\"><\/span>Database access parameters<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Host<\/strong>: information about the hostname can be found in the the mybox panel Beta, <strong><em>&#8220;Databases&#8221;<\/em><\/strong> tab, on the right, in the <strong><em>&#8220;Settings&#8221; box.<\/em><\/strong><\/li>\n\n\n\n<li><strong>Username<\/strong>: The username of your database<\/li>\n\n\n\n<li><strong>Password<\/strong>: The password generated when the database user was created<\/li>\n\n\n\n<li><strong>Database name<\/strong>: The name generated when the database was created<\/li>\n\n\n\n<li><strong>Database Port<\/strong>: 3306<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Management_Systems\"><\/span>Database Management Systems<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL\"><\/span>MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>&#8220;MySQL&#8221;<\/em><\/strong> is <strong>a multi-threaded and multi-user<\/strong> database management system (<strong>DBMS)<\/strong> developed by the Swedish company <strong><em>&#8220;MySQL AB&#8221;.<\/em><\/strong> <strong><em>&#8220;MySQL&#8221;<\/em><\/strong> includes great support for database replication (<strong>in master-slave&gt;<\/strong> mode). It also has excellent multilingual support \u2013 each table and even each field can have its own character encoding setting. &#8220;MySQL&#8221; offers different types of tables, each type of which is designed for a different use. The most commonly used are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>MyISAM<\/strong> \u2013 a fast, non-transactional type of tables. Only it allows full-text search.<\/li>\n\n\n\n<li><strong>InnoDB<\/strong> \u2013 Slower than <strong>MyISAM<\/strong>, however, it compensates for supporting and logging transactions.<\/li>\n\n\n\n<li><strong>MEMORY<\/strong> (up to version 4.1 \u2013 <strong>HEAP<\/strong>) \u2013 the fastest, as everything is stored exclusively in RAM. However, it has a few limitations, including not storing data when the <strong><em>&#8220;MySQL&#8221;<\/em><\/strong> server is turned off.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>&#8220;MySQL&#8221;<\/em><\/strong> , on the other hand, enjoys the reputation of one of the fastest database servers, which makes it perfect as a server for frequently visited websites.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQLite\"><\/span>SQLite<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>&#8220;SQLite&#8221;<\/em><\/strong> \u2013 is a database management system and a C library implementing such a system, supporting <strong><em>the &#8220;SQL&#8221;<\/em><\/strong> ( <strong><em>Structured Query Language)<\/em><\/strong> language. It was created by <strong>Richard Hipp<\/strong> and is available under a <strong>public domain<\/strong> license. The project was launched in 2000. The library implements the <strong><em>&#8220;SQL&#8221;<\/em><\/strong> engine, giving you the ability to use the database without having to run a separate <strong>DBMS<\/strong> process. In many applications, and in particular in embedded systems, this solution is the most practical. The contents of the database are stored in one file (up to 2 TB). The <strong><em>&#8220;SQLite&#8221;<\/em><\/strong> database is maintained on disk using binary trees ( <strong>B-Tree<\/strong>). A separate tree is used for each of the tables and each of the indexes. Databases are saved as binary files. Their security is based on the security offered by the file system used. There is also a project that offers <strong><em>&#8220;SQLite&#8221;<\/em><\/strong> database encryption on an ongoing basis.<\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[283,1114,389,1115,637,1116,772,1117,801,1118,802,1119,805,1120,806,1121,968,1122,978,1123,1108,1124,1109,1125,1110,1126,1111,226,1112,242,1113],"class_list":["post-935","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-mybox-panel","manual_kb_tag-data-model","manual_kb_tag-database-backup","manual_kb_tag-mysql-server","manual_kb_tag-database-credentials","manual_kb_tag-myisam","manual_kb_tag-domain","manual_kb_tag-innodb","manual_kb_tag-mysql","manual_kb_tag-sqlite","manual_kb_tag-database-management-system","manual_kb_tag-full-text-search","manual_kb_tag-structured-query-language","manual_kb_tag-database-replication","manual_kb_tag-database-security","manual_kb_tag-master-slave-replication","manual_kb_tag-databases","manual_kb_tag-transactional-tables","manual_kb_tag-helpdesk","manual_kb_tag-non-transactional-tables","manual_kb_tag-database","manual_kb_tag-embedded-database","manual_kb_tag-dbms","manual_kb_tag-database-encryption","manual_kb_tag-database-restore","manual_kb_tag-file-based-database","manual_kb_tag-backup-restoration","manual_kb_tag-customer-service","manual_kb_tag-database-access","manual_kb_tag-mybox","manual_kb_tag-database-port"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/935\/revisions"}],"predecessor-version":[{"id":3917,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/935\/revisions\/3917"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=935"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=935"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}