{"id":1162,"date":"2019-12-18T12:01:01","date_gmt":"2019-12-18T12:01:01","guid":{"rendered":"https:\/\/sectigostore.com\/page\/?p=1162"},"modified":"2019-12-18T12:01:02","modified_gmt":"2019-12-18T12:01:02","slug":"how-to-schedule-automatic-mysql-backups","status":"publish","type":"post","link":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/","title":{"rendered":"How to Schedule Automatic MySQL Backups"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Walkthrough of MySQL backup processes Using Linux and CodeGuard<\/h2>\n\n\n\n<p>Creating backups for your website data is a tedious and time-consuming process \u2014 and that\u2019s without the human errors that could result from pressing the wrong key or forgetting to create a backup. You can choose to schedule MySQL auto backups to make the process simpler and more efficient by using scripts such as automysqlbackup. You can also opt for automation tools like CodeGuard that are simple to set up, easy to use, and come packed with features such as malware scans to keep your data secure.<\/p>\n\n\n\n<div class=\"graysection\">\n<h2>Get CodeGuard for Only $1.63\/Month!<\/h2>\n<p>Schedule Automatic FTP Backup with CodeGuard. Buy it Today and Save Up to 50% With SectigoStore! <\/p>\n<a class=\"greenbutton\" style=\"text-decoration: none;\" href=\"https:\/\/sectigostore.com\/codeguard\/backup\">Shop Now<\/a>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL Scheduled Backup: AutoMySQLBackup<\/strong><\/h2>\n\n\n\n<p>MySQL scheduled backups can be done using AutoMySQLBackup. Follow the steps below to install and configure the package according to your needs:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>To automatically back up your database you will first need to install the <a href=\"https:\/\/www.linux.com\/tutorials\/how-do-painless-mysql-server-backups-automysqlbackup\/\">automysqlbackup<\/a> package.  <\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code>$ wget http:\/\/ ufpr.dl.sourceforge.net\/project\/automysqlbackup\/AutoMySQLBackup\/AutoMySQLBackup%20VER%203.0\/automysqlbackup-v3.0_rc6.tar.gz<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>$ tar zxvf automysqlbackup-v3.0_rc6.tar.gz<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Once the installation is complete, run the install.sh script with root privileges.<\/li><\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Once the setup is complete, navigate to the \u201c\/etc\/automysqlbackup\/\u201d directory to <a href=\"https:\/\/www.youtube.com\/watch?v=6qSSfn8NDRE\">edit the myserver.conf<\/a> file and modify it based on your preferences. You can uncomment the settings, schedule backups, insert database names, etc. as required.<\/li><\/ul>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>You can execute automysqlbackup in a variety of ways. You can create a script \u201crunmysqlbackup\u201d using the following lines of code: <\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/sh<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/local\/bin\/automysqlbackup \/etc\/automysqlbackup\/myserver.conf<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>chown root.root \/var\/backup\/db* -R<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>find \/var\/backup\/db* -type f -exec chmod 400 {} \\;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>find \/var\/backup\/db* -type d -exec chmod 700 {} \\;<\/code><\/pre>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Save it to your \/etc\/cron.daily folder and make sure it has executable file permissions. Set file permissions using the following command: chmod +x \/etc\/cron.daily\/runmysqlbackup. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Make MySQL Auto Backup Easy with CodeGuard<\/h2>\n\n\n\n<p>CodeGuard is an automated backup solution for keeping copies of your website data securely on the cloud. It safeguards you from experiencing massive downtime for issues relating to data loss and acts like an undo button. If something goes wrong with your site while you\u2019re using CodeGuard, you can revert your website to the last clean version with a single click. <\/p>\n\n\n\n<p>CodeGuard accesses your site either through the FTP\/SFTP protocol or through a <a href=\"https:\/\/codeguard.zendesk.com\/hc\/en-us\/articles\/115000621403-How-do-I-install-the-WordPress-plugin-\">WordPress<\/a> plugin. Based upon how you choose to set it up, it can back up a few files, copy the entire website, or only make a copy of the data that has changed.<\/p>\n\n\n\n<p>MySQL auto backup can be done using CodeGuard, log in to your CodeGuard dashboard, and follow the steps mentioned below:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1: Choose Your Backup Option<\/strong><\/h2>\n\n\n\n<p>Using a WordPress plugin is a possible option, but it is recommended to use the FTP\/SFTP option.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"379\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png\" alt=\"Add a website in codeguard backup\" class=\"wp-image-1171\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-300x111.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-768x284.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup.png 1121w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2: Obtain the Required Information to Add Your Website<\/strong><\/h2>\n\n\n\n<p>When <strong>adding a website<\/strong> using FTP\/SFTP, get details from your hosting provider such as: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>the URL of the website you want\nto add, <\/li><li>the FTP or SFTP server, <\/li><li>user credentials, and <\/li><li>port number. <\/li><\/ul>\n\n\n\n<p>You can find this information under settings in your hosting account. Use SFTP instead of FTP whenever possible because it\u2019s more secure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"871\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials.png\" alt=\"Add your website with SFTP credentials\" class=\"wp-image-1172\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials.png 742w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials-256x300.png 256w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3: Select Your Root Directory<\/strong><\/h2>\n\n\n\n<p>Once the connection is successful, in the Capture Your Code page, select or manually specify your <strong>Root Directory<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"572\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code.png\" alt=\"Capture Your Code\" class=\"wp-image-1173\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code.png 767w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code-300x224.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4: Select the Contents to Backup<\/strong><\/h2>\n\n\n\n<p>After that\u2019s done, select the website content (specific files and folders) you\u2019d like and click <strong>Begin<\/strong> <strong>First Backup<\/strong>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"472\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/the-content-backup.png\" alt=\"The Content to Backup\" class=\"wp-image-1174\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/the-content-backup.png 747w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/the-content-backup-300x190.png 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 5: Add a Database from the Completion Window<\/strong><\/h2>\n\n\n\n<p>Once your first backup is completed, you will be taken to the completion window. From here, you can A<strong>dd a Database,<\/strong> or you can also do it from your website dashboard. Please note, you cannot add a database without adding a website first.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-1024x545.png\" alt=\"CodeGuard\" class=\"wp-image-1175\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-1024x545.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-300x160.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-768x408.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 6: Get Database Details<\/strong><\/h2>\n\n\n\n<p>To <a href=\"https:\/\/codeguard.zendesk.com\/hc\/en-us\/articles\/115000604663-CodeGuard-Database-Backup-Walkthrough\">add a database<\/a>, you will require: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>a database name, <\/li><li>MySQL hostname or IP, <\/li><li>username, <\/li><li>password, and <\/li><li>the port number (default port\n3306). <\/li><\/ul>\n\n\n\n<p>If you are unable to find the information in your hosting account, please contact the CodeGuard support team to help you with the details. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 7: Enter Database Credentials and Test Connection<\/strong><\/h2>\n\n\n\n<p>Access your CodeGuard dashboard, select the website for which you wish to add a database. This step will take you to the website\u2019s dashboard. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"905\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-1.png\" alt=\"Enter Database Credentials\" class=\"wp-image-1177\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-1.png 985w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-1-300x276.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-1-768x706.png 768w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/figure>\n\n\n\n<p>On the website dashboard, you will find an option to <strong>add your database<\/strong>. Once you click on it, you will be taken to the test database connection page where you need to enter your database\u2019s IP or hostname.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"740\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary.png\" alt=\"File Backup Summary\" class=\"wp-image-1178\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary.png 941w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-300x236.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-768x604.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"600\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection.png\" alt=\"Test Database Connection\" class=\"wp-image-1179\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection.png 708w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection-300x254.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/figure>\n\n\n\n<p>Enter your <strong>credentials<\/strong> to access your database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-db-credentials-1024x608.png\" alt=\"\" class=\"wp-image-1180\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-db-credentials-1024x608.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-db-credentials-300x178.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-db-credentials-768x456.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-db-credentials.png 1090w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the next section, select the databases you want to add, click on <strong>Add Database<\/strong>, and you\u2019re done!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"761\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/databases.png\" alt=\"Databases\" class=\"wp-image-1181\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/databases.png 995w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/databases-300x229.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/databases-768x587.png 768w\" sizes=\"auto, (max-width: 995px) 100vw, 995px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Walkthrough of MySQL backup processes Using Linux and CodeGuard Creating backups for your website data is a tedious and time-consuming process \u2014 and that\u2019s without the human errors that could result from pressing the wrong key or forgetting to create a backup. You can choose to schedule MySQL auto backups to make the process simpler and more efficient by using scripts such as automysqlbackup. You can also opt for automation tools like CodeGuard that are simple to set up, easy to use, and come packed with features such as malware <a href=\"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/\" class=\"more-link\">Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1162","post","type-post","status-publish","format-standard","hentry","category-codeguard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Schedule Automatic MySQL Backups - Ultimate Guide<\/title>\n<meta name=\"description\" content=\"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Schedule Automatic MySQL Backups - Ultimate Guide\" \/>\n<meta property=\"og:description\" content=\"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"SectigoStore\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sectigostore\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-18T12:01:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-18T12:01:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png\" \/>\n<meta name=\"author\" content=\"sectigostorepages\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:site\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sectigostorepages\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/\"},\"author\":{\"name\":\"sectigostorepages\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"headline\":\"How to Schedule Automatic MySQL Backups\",\"datePublished\":\"2019-12-18T12:01:01+00:00\",\"dateModified\":\"2019-12-18T12:01:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/\"},\"wordCount\":736,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/add-a-website-in-codegaurd-backup-1024x379.png\",\"articleSection\":[\"CodeGuard\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/\",\"name\":\"How to Schedule Automatic MySQL Backups - Ultimate Guide\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/add-a-website-in-codegaurd-backup-1024x379.png\",\"datePublished\":\"2019-12-18T12:01:01+00:00\",\"dateModified\":\"2019-12-18T12:01:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"description\":\"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/add-a-website-in-codegaurd-backup.png\",\"contentUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/add-a-website-in-codegaurd-backup.png\",\"width\":1121,\"height\":415},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/how-to-schedule-automatic-mysql-backups\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SSL Resources\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CodeGuard\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/codeguard\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Schedule Automatic MySQL Backups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\",\"name\":\"SectigoStore\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\",\"name\":\"sectigostorepages\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"caption\":\"sectigostorepages\"},\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/author\\\/sectigostorepages\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Schedule Automatic MySQL Backups - Ultimate Guide","description":"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.","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:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/","og_locale":"en_US","og_type":"article","og_title":"How to Schedule Automatic MySQL Backups - Ultimate Guide","og_description":"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.","og_url":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/","og_site_name":"SectigoStore","article_publisher":"https:\/\/www.facebook.com\/sectigostore\/","article_published_time":"2019-12-18T12:01:01+00:00","article_modified_time":"2019-12-18T12:01:02+00:00","og_image":[{"url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png","type":"","width":"","height":""}],"author":"sectigostorepages","twitter_card":"summary_large_image","twitter_creator":"@sectigostore","twitter_site":"@sectigostore","twitter_misc":{"Written by":"sectigostorepages","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#article","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/"},"author":{"name":"sectigostorepages","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"headline":"How to Schedule Automatic MySQL Backups","datePublished":"2019-12-18T12:01:01+00:00","dateModified":"2019-12-18T12:01:02+00:00","mainEntityOfPage":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/"},"wordCount":736,"commentCount":0,"image":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png","articleSection":["CodeGuard"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/","url":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/","name":"How to Schedule Automatic MySQL Backups - Ultimate Guide","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#primaryimage"},"image":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1024x379.png","datePublished":"2019-12-18T12:01:01+00:00","dateModified":"2019-12-18T12:01:02+00:00","author":{"@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"description":"We outline the entire process with all steps to Schedule Automatic MySQL Backups. Read now and start your Automatic MySQL backups with CodeGuard.","breadcrumb":{"@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#primaryimage","url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup.png","contentUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup.png","width":1121,"height":415},{"@type":"BreadcrumbList","@id":"https:\/\/sectigostore.com\/page\/how-to-schedule-automatic-mysql-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SSL Resources","item":"https:\/\/sectigostore.com\/page\/"},{"@type":"ListItem","position":2,"name":"CodeGuard","item":"https:\/\/sectigostore.com\/page\/codeguard\/"},{"@type":"ListItem","position":3,"name":"How to Schedule Automatic MySQL Backups"}]},{"@type":"WebSite","@id":"https:\/\/sectigostore.com\/page\/#website","url":"https:\/\/sectigostore.com\/page\/","name":"SectigoStore","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sectigostore.com\/page\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec","name":"sectigostorepages","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","caption":"sectigostorepages"},"url":"https:\/\/sectigostore.com\/page\/author\/sectigostorepages\/"}]}},"_links":{"self":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/comments?post=1162"}],"version-history":[{"count":0,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1162\/revisions"}],"wp:attachment":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/media?parent=1162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/categories?post=1162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/tags?post=1162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}