{"id":2957,"date":"2019-10-11T14:35:17","date_gmt":"2019-10-11T14:35:17","guid":{"rendered":"https:\/\/www.thesslstore.com\/knowledgebase\/?post_type=ht_kb&p=2957"},"modified":"2020-03-12T17:27:07","modified_gmt":"2020-03-12T17:27:07","slug":"back-up-mysql-database-codeguard","status":"publish","type":"ht_kb","link":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/","title":{"rendered":"How to Back Up a MySQL Database with CodeGuard"},"content":{"rendered":"\n

CodeGuard does far more than just back up websites, it can back up databases, too. Once you\u2019ve configured CodeGuard to back up your site via SFTP, CodeGuard backs up your SQL database in just a few steps, too.<\/p>\n

In this article we\u2019ll look at how to back up your MySQL database using CodeGuard.<\/p>\n

Before getting started, make sure you have your CodeGuard account active, you have access to your dashboard and you have already backed up your website files.<\/p>\n

    \n
  1. \n

    Get Started<\/strong><\/h4>\nIn the CodeGuard dashboard, next to your website, click the gear icon and select \u201cAdd Database.\u201d

    \"\"<\/a><\/li>\n
  2. \n

    Test Your Connection<\/strong><\/h4>\nThe next page will prompt you to test your connection. Just enter your database hostname (typically the IP address for your website) and click \u201cTest Connection\u201d. CodeGuard will test to see if it\u2019s allowed to connect directly to your database. If not, you\u2019ll need to whitelist CodeGuard\u2019s IP addresses \u2013 see our whitelist how to articles here<\/a>.

    \"\"<\/a><\/li>\n
  3. \n

    Enter Credentials<\/strong><\/h4>\nMost site owners will choose to use the default option, \u201cDirect MySQL\u201d. Next, you\u2019ll need to indicate the settings for your MySQL database connection.

    Tip<\/strong>: if you\u2019re not sure what your MySQL username and password are, you can find them in your website configuration file. For example, if you\u2019re using WordPress, your configuration file is wp-config.php. Afterwards, click Next Step.<\/li>\n
  4. \n

    Select Databases<\/strong><\/h4>\nFinally, select which database(s) you want to backup and click \u201cAdd Databases\u201d.<\/li>\n<\/ol>\n

    Congratulations, your database will now be backed up the frequency of your choosing.<\/p>\n","protected":false},"excerpt":{"rendered":"

    CodeGuard does far more than just back up websites, it can back up databases, too. Once you\u2019ve configured CodeGuard to back up your site via SFTP, CodeGuard backs up your SQL database in just a few steps, too. In this article we\u2019ll look at how to back up your MySQL…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[63],"ht-kb-tag":[],"class_list":["post-2957","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-other-codeguard"],"yoast_head":"\nHow to Back Up a MySQL Database with CodeGuard - Knowledge Base<\/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:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Back Up a MySQL Database with CodeGuard - Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"CodeGuard does far more than just back up websites, it can back up databases, too. Once you\u2019ve configured CodeGuard to back up your site via SFTP, CodeGuard backs up your SQL database in just a few steps, too. In this article we\u2019ll look at how to back up your MySQL...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/thesslstoredotcom\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-12T17:27:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2019\/10\/1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"230\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@thesslstore\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Back Up a MySQL Database with CodeGuard - Knowledge Base","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:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/","og_locale":"en_US","og_type":"article","og_title":"How to Back Up a MySQL Database with CodeGuard - Knowledge Base","og_description":"CodeGuard does far more than just back up websites, it can back up databases, too. Once you\u2019ve configured CodeGuard to back up your site via SFTP, CodeGuard backs up your SQL database in just a few steps, too. In this article we\u2019ll look at how to back up your MySQL...","og_url":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/","og_site_name":"Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/thesslstoredotcom","article_modified_time":"2020-03-12T17:27:07+00:00","og_image":[{"width":230,"height":410,"url":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2019\/10\/1-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@thesslstore","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/","url":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/","name":"How to Back Up a MySQL Database with CodeGuard - Knowledge Base","isPartOf":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/#primaryimage"},"image":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/#primaryimage"},"thumbnailUrl":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2019\/10\/1-1.png","datePublished":"2019-10-11T14:35:17+00:00","dateModified":"2020-03-12T17:27:07+00:00","breadcrumb":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/#primaryimage","url":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2019\/10\/1-1.png","contentUrl":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2019\/10\/1-1.png","width":230,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/other-codeguard\/back-up-mysql-database-codeguard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.thesslstore.com\/knowledgebase\/"},{"@type":"ListItem","position":2,"name":"How to Back Up a MySQL Database with CodeGuard"}]},{"@type":"WebSite","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#website","url":"https:\/\/www.thesslstore.com\/knowledgebase\/","name":"Knowledge Base","description":"TheSSLstore","publisher":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.thesslstore.com\/knowledgebase\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#organization","name":"The SSL Store\u2122","url":"https:\/\/www.thesslstore.com\/knowledgebase\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#\/schema\/logo\/image\/","url":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/04\/thesslstore.jpg","contentUrl":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-content\/uploads\/2017\/04\/thesslstore.jpg","width":300,"height":300,"caption":"The SSL Store\u2122"},"image":{"@id":"https:\/\/www.thesslstore.com\/knowledgebase\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/thesslstoredotcom","https:\/\/x.com\/thesslstore","https:\/\/www.linkedin.com\/company\/the-ssl-store","https:\/\/www.youtube.com\/user\/thesslstore"]}]}},"_links":{"self":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/2957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=2957"}],"version-history":[{"count":0,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/2957\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=2957"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=2957"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.thesslstore.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=2957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}