{"id":56650,"date":"2023-09-11T12:44:11","date_gmt":"2023-09-11T09:44:11","guid":{"rendered":"https:\/\/tuthost.ua\/faq\/how-to-do-import-export-of-a-large-size-database\/"},"modified":"2024-07-19T19:17:20","modified_gmt":"2024-07-19T16:17:20","slug":"how-to-do-import-export-of-a-large-size-database","status":"publish","type":"ht_kb","link":"https:\/\/tuthost.ua\/en\/faq\/how-to-do-import-export-of-a-large-size-database\/","title":{"rendered":"How to do import\/export of a large size database?"},"content":{"rendered":"\n<p>Database size allowed for loading through the PhpMyAdmin interface<\/p>\n\n<p>is limited by the PHP parameters post_max_size and upload_max_filesize.  <\/p>\n\n<p>(usually 100-200 MB), so if the database dump volume exceeds these parameters, you can download the dump using SSH access.<\/p>\n\n<p>In the DirectAdmin control panel is available Web SSH Client, for authorization use the same access data as for DirectAdmin.<\/p>\n\n<p>Before you import the sql dump, you need to create a database in the DirectAdmin hosting control panel &#8211; <a href=\"https:\/\/tuthost.ua\/en\/faq\/kak-sozdat-bazu-dannyh-mysql\/\">https:\/\/tuthost.ua\/faq\/kak-sozdat-bazu-dannyh-mysql\/<\/a>.<\/p>\n\n<p>Use the following command to import:<\/p>\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><em>mysql &#8211;user=user &#8211;password=password name_database_data &lt; file_dump.sql<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\n<p>Use the following command to export the database:<\/p>\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><em>mysqldump &#8211;user=user &#8211;password=password name_database_data file_dump.sql<\/em><\/td><\/tr><\/tbody><\/table><\/figure>","protected":false},"excerpt":{"rendered":"<p>Database size allowed for loading through the PhpMyAdmin interface is limited by the PHP parameters post_max_size and upload_max_filesize. (usually 100-200 MB), so if the database dump volume exceeds these parameters, you can download the dump using SSH access. In the DirectAdmin control panel is available Web SSH Client, for authorization use the same access data&#8230;<\/p>\n","protected":false},"author":13,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","ghostkit_customizer_options":"","ghostkit_custom_css":"","ghostkit_custom_js_head":"","ghostkit_custom_js_foot":"","ghostkit_typography":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"ht-kb-category":[10669],"ht-kb-tag":[],"class_list":["post-56650","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting-en"],"taxonomy_info":{"ht_kb_category":[{"value":10669,"label":"Hosting"}]},"featured_image_src_large":[],"author_info":{"display_name":"\u0414\u0430\u0432\u0438\u0434","author_link":"https:\/\/tuthost.ua\/en\/author\/david-tuthost-com\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/56650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/comments?post=56650"}],"version-history":[{"count":1,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/56650\/revisions"}],"predecessor-version":[{"id":56651,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/56650\/revisions\/56651"}],"wp:attachment":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/media?parent=56650"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb-category?post=56650"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=56650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}