{"id":9125,"date":"2023-12-15T13:04:12","date_gmt":"2023-12-15T13:04:12","guid":{"rendered":"https:\/\/truehost.com\/support\/?post_type=ht_kb&#038;p=9125"},"modified":"2024-09-23T11:17:40","modified_gmt":"2024-09-23T11:17:40","password":"","slug":"import-export-database-on-cloudpanel","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/","title":{"rendered":"How to Import\/Export database on CloudPanel"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Importing and exporting a database in CloudPanel follows a series of steps.In this guide, we will look at how to import and\/or export databases in CloudPanel.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Importing a database<\/strong><\/p>\n\n\n\n<p>We need to upload the database.sql(.zip) file to your VPS. We can upload through the dashboard. First access your website dashboard. Then click File Manager tab, navigate to the folder where you want to upload your database file.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Log in to your VPS via ssh terminal or PuTTY as root, then navigate to the folder where you uploaded your database file and run the following command:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><code>clpctl db:import --databaseName=my-database --file=dump.sql.gz<\/code><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><div class=\"open_grepper_editor\" title=\"Edit &amp; Save To Grepper\"><\/div><\/pre>\n\n\n\n<p>Replace my-database and dump.sql.gz with the database name and database file respectively. If successful, the output will indicate the import was successful.<\/p>\n\n\n\n<p><strong>Exporting a database<\/strong><\/p>\n\n\n\n<p>Access your VPS and navigate to the folder where you want to export your database. Then run the following command to export your database:<\/p>\n\n\n\n<p><code>clpctl db:export --databaseName=my-database --file=dump.sql.gz<\/code><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><\/pre>\n\n\n\n<p>The&nbsp;<strong>database dump<\/strong>&nbsp;will be&nbsp;<strong>gzipped<\/strong>&nbsp;if you add&nbsp;<strong>.sql.gz<\/strong>&nbsp;at the end of the file name. If you want to export the database uncompressed, use&nbsp;<strong>.sql<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importing and exporting a database in CloudPanel follows a series of steps.In this guide, we will look at how to import and\/or export databases in CloudPanel. Importing a database We need to upload the database.sql(.zip) file to your VPS. We can upload through the dashboard. First access your website dashboard. Then click File Manager tab, [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[2132],"doc_tag":[],"class_list":["post-9125","docs","type-docs","status-publish","hentry","doc_category-cloudpanel"],"year_month":"2026-06","word_count":203,"total_views":"0","reactions":{"happy":"24","normal":"0","sad":"0"},"author_info":{"name":"Ian M","author_nicename":"ian","author_url":"https:\/\/truehost.com\/support\/author\/ian\/"},"doc_category_info":[{"term_name":"Cloudpanel","term_url":"https:\/\/truehost.com\/support\/docs-category\/cloudpanel\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Import\/Export database on CloudPanel -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import\/Export database on CloudPanel -\" \/>\n<meta property=\"og:description\" content=\"Importing and exporting a database in CloudPanel follows a series of steps.In this guide, we will look at how to import and\/or export databases in CloudPanel. Importing a database We need to upload the database.sql(.zip) file to your VPS. We can upload through the dashboard. First access your website dashboard. Then click File Manager tab, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-23T11:17:40+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/import-export-database-on-cloudpanel\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/import-export-database-on-cloudpanel\\\/\",\"name\":\"How to Import\\\/Export database on CloudPanel -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"datePublished\":\"2023-12-15T13:04:12+00:00\",\"dateModified\":\"2024-09-23T11:17:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/import-export-database-on-cloudpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/import-export-database-on-cloudpanel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/import-export-database-on-cloudpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import\\\/Export database on CloudPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import\/Export database on CloudPanel -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/","og_locale":"en_US","og_type":"article","og_title":"How to Import\/Export database on CloudPanel -","og_description":"Importing and exporting a database in CloudPanel follows a series of steps.In this guide, we will look at how to import and\/or export databases in CloudPanel. Importing a database We need to upload the database.sql(.zip) file to your VPS. We can upload through the dashboard. First access your website dashboard. Then click File Manager tab, [&hellip;]","og_url":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/","article_modified_time":"2024-09-23T11:17:40+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/","url":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/","name":"How to Import\/Export database on CloudPanel -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"datePublished":"2023-12-15T13:04:12+00:00","dateModified":"2024-09-23T11:17:40+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/knowledge-base\/import-export-database-on-cloudpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Import\/Export database on CloudPanel"}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/9125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=9125"}],"version-history":[{"count":5,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/9125\/revisions"}],"predecessor-version":[{"id":14065,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/9125\/revisions\/14065"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=9125"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=9125"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=9125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}