{"id":633,"date":"2025-12-19T06:18:53","date_gmt":"2025-12-19T05:18:53","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&p=633"},"modified":"2025-12-19T06:18:54","modified_gmt":"2025-12-19T05:18:54","slug":"how-to-manage-and-clean-the-database-with-a-plugin-for-cms-wordpress","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-to-manage-and-clean-the-database-with-a-plugin-for-cms-wordpress\/","title":{"rendered":"How to manage and clean the database with a plugin for CMS WordPress?"},"content":{"rendered":"\n
\n

If the database of your website in “WordPress” <\/strong><\/em>has grown significantly for no specific reason, i.e. new publications or products have not been added to the store based on the “WooCommerce”<\/strong><\/em> plugin, a very common reason is that the plugin collects and saves information in the database about the visits of potential customers.
This type of action can be performed both by the “WooCommerce”<\/strong><\/em> plugin and by others whose task is to collect statistics.<\/p>\n\n\n\n

While statistical data is important, when every visit is recorded, even the one that didn’t end in a sale, the size of the database can grow rapidly.<\/p>\n\n\n\n<\/div>\n\n

\r\n
\r\n
\r\n \"Info\"\r\n <\/div>\r\n
\r\n Early access<\/span><\/span>\r\n

Still need help?<\/span><\/h4>\r\n

Contact our customer service team.<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n\r\n

\r\n Message us<\/span><\/a>\r\n <\/div>\r\n<\/div><\/div>\n\n

In such a situation, the WP Data Access <\/a>plugin may be helpful, which will allow you to open a view of tables in the database from ” WordPress”<\/strong><\/em> and, if necessary, have them cleaned by selecting the Truncate<\/strong> option.<\/p>\n\n\n\n

The plugin allows you to directly access your website’s database tables, so it’s a tool designed mainly for webmasters\/developers. Minimal knowledge of the operation and construction of the database is recommended.<\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[25,58],"manual_kb_tag":[2750,2751,2752,2753,190,198,585,2147,2748,2749],"class_list":["post-633","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-hosting","manualknowledgebasecat-web-applications-cms","manual_kb_tag-database-cleanup","manual_kb_tag-clean-wordpress-database","manual_kb_tag-truncate-tables","manual_kb_tag-data-access-plugin","manual_kb_tag-wordpress","manual_kb_tag-woocommerce","manual_kb_tag-database-tables","manual_kb_tag-database-optimization","manual_kb_tag-database-growth","manual_kb_tag-database-bloat"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/633","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":0,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/633\/revisions"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=633"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=633"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}