{"id":35276,"date":"2026-08-17T13:36:09","date_gmt":"2026-08-17T13:36:09","guid":{"rendered":"https:\/\/1grid.co.za\/knowledge\/?post_type=ht_kb&#038;p=35276"},"modified":"2026-08-17T13:36:10","modified_gmt":"2026-08-17T13:36:10","slug":"how-to-export-a-mysql-database-via-ssh-with-1-grid","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/","title":{"rendered":"How to Export a MySQL Database via SSH with 1-grid"},"content":{"rendered":"\n<h4 id=\"htoc-back-up-large-mysql-databases-quickly-and-reliably-using-secure-command-line-tools-without-browser-timeouts\" class=\"wp-block-heading\">Back up large MySQL databases quickly and reliably using secure command-line tools without browser timeouts.<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If you need to create a backup of your MySQL database, you can use SSH to export the database directly from your hosting environment on your 1-grid Client Portal account. This is especially useful for larger databases where browser-based tools like How to Access phpMyAdmin may experience processing or timeout limits. This guide shows you how to connect via SSH Access, create a <code>mysqldump<\/code> backup, compress the file, and download it safely.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"600\" src=\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/08\/1-grid-Images-for-KB-Articles-1000-x-600-px-54.png\" alt=\"How to Export a MySQL Database via SSH with 1-grid\" class=\"wp-image-35278\"\/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-ht-block-toc is-style-rounded htoc htoc--position-wide toc-list-style-plain\" data-htoc-state=\"expanded\"><span class=\"htoc__title\"><span class=\"ht_toc_title\">Table of Contents<\/span><span class=\"htoc__toggle\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"16\" height=\"16\"><g fill=\"#444\"><path d=\"M15 7H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><path d=\"M15 1H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1zM15 13H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><\/g><\/svg><\/span><\/span><div class=\"htoc__itemswrap\"><ul class=\"ht_toc_list\"><li class=\"\"><a href=\"#htoc-before-you-begin\">Before You Begin<\/a><\/li><li class=\"\"><a href=\"#htoc-follow-these-steps\">Follow These Steps<\/a><ul class=\"ht_toc_child_list\"><\/ul><\/li><li class=\"\"><a href=\"#htoc-what-happens-next\">What Happens Next?<\/a><\/li><li class=\"\"><a href=\"#htoc-keep-your-backups-safe\">Keep Your Backups Safe<\/a><\/li><li class=\"\"><a href=\"#htoc-you-re-ready\">You\u2019re Ready!<\/a><\/li><li class=\"\"><a href=\"#htoc-related-articles\">Related Articles<\/a><\/li><li class=\"\"><a href=\"#htoc-need-help\">Need Help?<\/a><\/li><\/ul><\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-before-you-begin\" class=\"wp-block-heading\">Before You Begin<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before exporting your database via SSH, make sure you have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-access-to-your-1-grid-client-portal\">Access to your <strong>1-grid Customer Zone<\/strong><\/li>\n\n\n\n<li id=\"htoc-an-active-hosting-account-with-ssh-access-enabled\">An active hosting account with <strong>SSH access<\/strong> enabled<\/li>\n\n\n\n<li id=\"htoc-your-exact-database-name-username-and-password-see-how-to-create-a-mysql-database-and-how-to-create-a-database-user\">Your exact database name, username, and password (see <strong><a href=\"https:\/\/1grid.co.za\/knowledge\/?s=create+MySQL&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a MySQL Database<\/a> <\/strong>and <a href=\"https:\/\/1grid.co.za\/knowledge\/?s=create+MySQL+user&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Create a Database User<\/strong><\/a>)<\/li>\n\n\n\n<li id=\"htoc-enough-storage-space-on-your-server-for-the-backup-file-and-a-secure-location-to-download-it-to\">Enough storage space on your server for the backup file and a secure location to download it to<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udca1 <em><strong>Tip:<\/strong> If you&#8217;re unsure which database belongs to your platform, check your website&#8217;s configuration files before running commands.<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-follow-these-steps\" class=\"wp-block-heading\">Follow These Steps<\/h2>\n\n\n\n<h4 id=\"htoc-1-open-your-hosting-service\" class=\"wp-block-heading\">1. Open Your Hosting Service<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/1-grid.com\/client\/index.php?rp=\/login\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Log in <\/strong><\/a>to your <a href=\"https:\/\/1-grid.com\/client\/index.php?rp=\/login\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>1-grid Customer Zone <\/strong><\/a>and open the hosting service associated with the database you want to export. Confirm that SSH access is available. If SSH isn&#8217;t available, use <a href=\"https:\/\/1grid.co.za\/knowledge\/?s=phpMyAdmin&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Access phpMyAdmin<\/strong><\/a> instead.<\/p>\n\n\n\n<h4 id=\"htoc-2-connect-using-ssh\" class=\"wp-block-heading\">2. Connect Using SSH<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Use an SSH client (such as <strong><a href=\"https:\/\/1grid.co.za\/knowledge\/?s=putty&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\">PuTTY<\/a> <\/strong>on Windows, or Terminal on macOS and Linux) to connect to your hosting account using your SSH credentials.<\/p>\n\n\n\n<h4 id=\"htoc-3-export-your-mysql-database\" class=\"wp-block-heading\">3. Export Your MySQL Database<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Once connected through SSH, run the following command:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>bash<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u database_username -p database_name > backup.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use code with caution.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>(Replace <code>database_username<\/code> and <code>database_name<\/code> with your actual database details. Enter your database password when prompted. Never put your password directly in the command string).<\/em><\/p>\n\n\n\n<h4 id=\"htoc-4-wait-for-the-export-to-complete\" class=\"wp-block-heading\">4. Wait for the Export to Complete<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Larger databases may take several minutes to process. Allow the command to finish completely and return to the prompt without errors before closing your session.<\/p>\n\n\n\n<h4 id=\"htoc-5-compress-the-backup-optional\" class=\"wp-block-heading\">5. Compress the Backup (Optional)<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If your generated <code>.sql<\/code> backup file is large, compress it to save space and speed up transfers by running:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>bash<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gzip backup.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use code with caution.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This creates a compressed <code>backup.sql.gz<\/code> archive.<\/p>\n\n\n\n<h4 id=\"htoc-6-download-your-backup\" class=\"wp-block-heading\">6. Download Your Backup<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Download your backup using<strong> <a href=\"https:\/\/1grid.co.za\/knowledge\/?s=SFTP&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\">SFTP<\/a><\/strong>,<strong> <a href=\"https:\/\/1grid.co.za\/knowledge\/?s=FTP&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\">FTP<\/a><\/strong>, or<strong> <a href=\"https:\/\/1grid.co.za\/knowledge\/?s=File+Manager&amp;ht-kb-search=1&amp;lang=\" target=\"_blank\" rel=\"noreferrer noopener\">File Manager<\/a><\/strong>. Store the file safely on your local device or an external location.<\/p>\n\n\n\n<h4 id=\"htoc-7-verify-your-backup\" class=\"wp-block-heading\">7. Verify Your Backup<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Confirm that the backup file exists, has a realistic file size, and downloads successfully before deleting anything from the server.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-what-happens-next\" class=\"wp-block-heading\">What Happens Next?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Exporting creates a copy of your database without interrupting your live website. Note that database exports contain database information only; they do not include website files or images. For a complete migration, make sure you <a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-backup-website-files-via-file-manager-and-database-via-phpmyadmin\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Back Up Website Files<\/strong><\/a> separately.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-keep-your-backups-safe\" class=\"wp-block-heading\">Keep Your Backups Safe<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-maintain-multiple-backup-versions-outside-of-your-hosting-server-environment\">Maintain multiple backup versions outside of your hosting server environment.<\/li>\n\n\n\n<li id=\"htoc-always-generate-a-fresh-backup-before-performing-major-site-updates-or-software-upgrades\">Always generate a fresh backup before performing major site updates or software upgrades.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-if-this-didn-t-work\" class=\"wp-block-heading\">If This Didn&#8217;t Work<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If <code>mysqldump<\/code> returns an error, verify that your database name and credentials are correct, your user has proper permissions, and your server has available disk space. Should issues persist, contact support with the exact error message and command used (excluding passwords).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-you-re-ready\" class=\"wp-block-heading\">You\u2019re Ready!<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You have successfully exported your MySQL database via SSH. Keep your downloaded copy secure and verified for future deployment needs.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-theme-default-background-color has-background wp-element-button\" href=\"https:\/\/1-grid.com\/client\/index.php?rp=\/login\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Log In to Customer Zone &amp; Manage Hosting Now<\/strong><\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-related-articles\" class=\"wp-block-heading\">Related Articles<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li id=\"htoc-how-to-import-a-mysql-database-via-ssh\"><a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-import-a-mysql-database-via-ssh-with-1-grid\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Import a MySQL Database via SSH<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-\"><a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-recover-a-mysql-database-in-cpanel-with-1-grid\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Recover a MySQL Database in cPanel with 1-grid<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-how-to-create-a-mysql-database\"><a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-create-a-mysql-database-in-cpanel\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Create a MySQL Database (cPanel)<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-how-to-create-a-database-user\"><a href=\"https:\/\/1grid.co.za\/knowledge\/how-to-create-a-mysql-database-user-in-cpanel\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Create a Database User (cPanel)<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-1\"><a href=\"https:\/\/1grid.co.za\/knowledge\/page\/2\/?s=MySQL&amp;ht-kb-search=1&amp;lang#:~:text=How%20to%20Manage%20a%20MySQL%20Database%20with%20PHPMyAdmin%20in%20cPanel\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Manage a MySQL Database with phpMyAdmin in cPanel<\/strong><\/a><\/li>\n\n\n\n<li id=\"htoc-how-to-access-phpmyadmin\"><a href=\"https:\/\/1grid.co.za\/knowledge\/page\/2\/?s=MySQL&amp;ht-kb-search=1&amp;lang#:~:text=How%20to%20Import%20a%20MySQL%20Database%20using%20phpMyAdmin\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>How to Import a MySQL Database using phpMyAdmin<\/strong><\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 id=\"htoc-need-help\" class=\"wp-block-heading\">Need Help?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;re unable to complete your database export or encounter an unexpected error, <a href=\"https:\/\/1grid.co.za\/contact-us\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>contact us<\/strong><\/a>. Our Support team is here to help. Have your domain name, database name, and the command used (without your password) ready.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Back up large MySQL databases quickly and reliably using secure command-line tools without browser timeouts. If you need to create a backup of your MySQL database, you can use SSH to export the database directly from your hosting environment on your 1-grid Client Portal account. This is especially useful for&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1174],"ht-kb-tag":[1858,238,270,1961,1963,470,662,947,949,1910],"class_list":["post-35276","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_tag-advanced-hosting","ht_kb_tag-cpanel","ht_kb_tag-database","ht_kb_tag-database-backup","ht_kb_tag-database-export","ht_kb_tag-hosting","ht_kb_tag-mysql","ht_kb_tag-sql","ht_kb_tag-ssh","ht_kb_tag-website-backup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Export a MySQL Database via SSH | 1-grid<\/title>\n<meta name=\"description\" content=\"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export a MySQL Database via SSH | 1-grid\" \/>\n<meta property=\"og:description\" content=\"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-17T13:36:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/08\/1-grid-Images-for-KB-Articles-1000-x-600-px-54.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/\",\"name\":\"How to Export a MySQL Database via SSH | 1-grid\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2026-08-17T13:36:09+00:00\",\"dateModified\":\"2026-08-17T13:36:10+00:00\",\"description\":\"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Export a MySQL Database via SSH with 1-grid\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Export a MySQL Database via SSH | 1-grid","description":"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.","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:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/","og_locale":"en_US","og_type":"article","og_title":"How to Export a MySQL Database via SSH | 1-grid","og_description":"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.","og_url":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2026-08-17T13:36:10+00:00","og_image":[{"url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2026\/08\/1-grid-Images-for-KB-Articles-1000-x-600-px-54.png"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/","url":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/","name":"How to Export a MySQL Database via SSH | 1-grid","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2026-08-17T13:36:09+00:00","dateModified":"2026-08-17T13:36:10+00:00","description":"Learn how to export a MySQL database via SSH with 1-grid, create a secure SQL backup, compress the file and download it for safe storage.","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/how-to-export-a-mysql-database-via-ssh-with-1-grid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"How to Export a MySQL Database via SSH with 1-grid"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/35276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=35276"}],"version-history":[{"count":4,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/35276\/revisions"}],"predecessor-version":[{"id":35284,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/35276\/revisions\/35284"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=35276"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=35276"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=35276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}