{"id":1580,"date":"2019-06-13T09:29:59","date_gmt":"2019-06-13T09:29:59","guid":{"rendered":"https:\/\/dev.outrightcrm.in\/dev\/store\/?p=1580"},"modified":"2025-01-28T12:06:58","modified_gmt":"2025-01-28T12:06:58","slug":"suitecrm-automation-backup-restore","status":"publish","type":"post","link":"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/suitecrm-automation-backup-restore\/","title":{"rendered":"Automation of Backup and Restore of MySQL Databases Using SuiteCRM or SugarCRM"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Importance of Data backup and recovery process!<br><br><\/h2>\n\n\n\n<p>So you are into a business!, which runs on crucial <a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/database-backup-and-restore-manager\/\" target=\"_blank\" rel=\"noreferrer noopener\">Backup and Restore data<\/a>, data manipulated the whole day. It does not matter how big you are, data is important.<\/p>\n\n\n\n<p>At some point, you worried about disasters, downtime or data loss?&nbsp;May be that costs a serious money to you?<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why Businesses Need to Regularly Backup databases!<br><br><\/h2>\n\n\n\n<p>So here is a bad story, you wake up in the morning, got to know your websites were hacked, you have a data loss, that\u2019s not your favorite day, you will run to ask IT support or it may be worse situation?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2019\/06\/Where-are-my-backups.webp\" alt=\"SuiteCRM Backup\" class=\"wp-image-1581\"\/><figcaption class=\"wp-element-caption\"> <br><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">What if you had planned for it before?<br><br><\/h3>\n\n\n\n<pre><p><b>1)<\/b>You  have regular databases overnight \/ lunchtime  \/before morning \/ after \n  office time, at least 4 database backup on a regular basis?<\/p><\/blockquote><\/p><p><blockquote class=\"wp-block-quote\"><p><b>2)<\/b>Do you already know how to restore them quickly without calling it day loss?<\/p><\/blockquote><\/p><p><blockquote class=\"wp-block-quote\"><p><b>3)<\/b>I don\u2019t need to search for blogs or  learn new things to restore, \n  I am already stressed!!<\/p><\/pre>\n\n\n\n<p>So might you already heard me,You have been several security issues or bad code, you got a data loss, the day when you come it to know, it may be serious money loss. <br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Life without backups<br><br><\/h2>\n\n\n\n<p>Many businesses do not know the importance of daily backups, they are not aware of it. Statistics says about it .<a rel=\"noreferrer noopener\" aria-label=\"https:\/\/www.dngnet.com\/data-backup-statistics\/ (opens in a new tab)\" href=\"https:\/\/www.dngnet.com\/data-backup-statistics\/\" target=\"_blank\">https:\/\/www.dngnet.com\/data-backup-statistics\/<\/a><\/p>\n\n\n\n<p><strong>Here is Sad Uber\u2019s story:   <\/strong><a rel=\"noreferrer noopener\" aria-label=\"https:\/\/www.theguardian.com\/technology\/2018\/nov\/27\/uber-fined-385000-for-data-breach-affecting-millions-of-passengers-hacked (opens in a new tab)\" href=\"https:\/\/www.theguardian.com\/technology\/2018\/nov\/27\/uber-fined-385000-for-data-breach-affecting-millions-of-passengers-hacked\" target=\"_blank\">https:\/\/www.theguardian.com\/technology\/2018\/nov\/27\/uber-fined-385000-for-data-breach-affecting-millions-of-passengers-hacked<\/a><\/p>\n\n\n\n<p>A small security leak can heart you in millions! There are ransomware, malware, and even a bad employee.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Why Automation is required? How it benefits to my business?<\/strong><br><br><\/h3>\n\n\n\n<p>Learning from above, we already know data backups are very important, it needs to be on a daily basis, timely managed. Now it needs to learn, this is a complete process including many steps.<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">1-<strong> <\/strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/product\/suitecrm-backup-restore-manager\/\">Database automatic backups &nbsp;<\/a><br><\/h4>\n\n\n\n<p>They can simply zip and put somewhere at a safe location, location can be on the same machine or any remote location. The remote location can be bound using FTP\/SFTP or SSH.<br><\/p>\n\n\n\n<p><strong>2- Database one-click restore<\/strong><br><\/p>\n\n\n\n<p>Restore Process must be simple, I don\u2019t need to become a techie, it must be one click. It also should give an option to restore any remote location. I don\u2019t need to download and upload it. Downloading and uploading can kill many hours. It should be one click and automated.<br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>3- Backup retention process <\/strong><br><\/h4>\n\n\n\n<p>Your disk may be getting full soon, why keep old backup zips, may be automatically deleted after a period of time like 3 days?<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>4- Timely maintenance window<\/strong><br><\/h4>\n\n\n\n<p>Backups must be done according to your timezone, it should know the time when your users are not into business, it should not affect users productive time.<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>5- Folder \/ Instance Backup<\/strong><br><\/h4>\n\n\n\n<p>You may have several files, documents that need to backup regularly, sitting into your folder. It also takes care of it.<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>6- Please Notify me!<\/strong><br><\/h4>\n\n\n\n<p>Did you see CCTVs camera in shopping malls, sometimes you come to know they are just installed and not working yet? So I was not knowing it because I was not informed. Learning from this, when you know above 5 things, you must get a notification on all processes.<br><\/p>\n\n\n\n<pre><b>1.<\/b>Notify me when a backup is going to start, when it completed and how      \n  many tables were there in the database, what was it\u2019s complete size after backup. \n  Sizes must be growing as time passes as your data is growing. A good sign my \n  backups are going fine.<\/p><p><b>2.<\/b>Notify me when a restore process started, tell me restored  database     \n  name, host location, total tables and many other info. <b>3.<\/b> Time to remove \n  old backups, Notify me first!!!<\/p><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>7- Test your backups instantly<\/strong><br><\/h4>\n\n\n\n<p> Just go through the UI of Backup and Restore window, It gives you the option of download, restore, and restore on remote location.<br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>8- Immediate Backup <\/strong><br><\/h4>\n\n\n\n<p> Do you need a backup right now, Our tool gives you the option of <strong>Instant\/Immediate backups<\/strong>. It\u2019s just one click.<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2019\/06\/Why-Automation-is-required_-How-it-benefits-to-my-business_.webp\" alt=\"Immediate backups\" class=\"wp-image-1604\"\/><figcaption class=\"wp-element-caption\"><br><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Why Restore Process is also Featured at Remote Location? Migrating your Database to a new server?<br><br><\/h2>\n\n\n\n<p><strong>Maybe you need a clone of the current instance, a development site, don\u2019t need to spend hours. Location can be on the same machine or remote, Automation takes care of it.<\/strong><br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Regular and Automated backups \u2013 Peace of Mind, Notifications make me happier!<br><br><\/h2>\n\n\n\n<p>Learning from above, keep you safe from that unlucky day, No matter if you have a malware attack, you have bad intentions employee or you are looking to clone your sites\/Databases Backup. You are safe and no matters you are not a techie, you can do everything on your own, moreover, you will be notified for the whole process on your email.<br><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2019\/06\/Thanks-to-Outright-Plugin.webp\" alt=\" Outright Plugin\" class=\"wp-image-1584\"\/><figcaption class=\"wp-element-caption\"><br><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">         <strong>   MAGIC OF ONE CLICK<\/strong><br><br><\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2019\/06\/One-Click.webp\" alt=\"One Click Backup\" class=\"wp-image-1585\"\/><figcaption class=\"wp-element-caption\"><br><\/figcaption><\/figure>\n\n\n\n<p>All the above processes are automated, at most manual interaction is one click, so the magic of one-click goes on.<br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><blockquote class=\"wp-block-quote\"><p>Create an immediate backup<\/p><\/blockquote><\/li>\n\n\n\n<li><blockquote class=\"wp-block-quote\"><p>Create an immediate restore<\/p><\/blockquote><\/li>\n\n\n\n<li><blockquote class=\"wp-block-quote\"><p>Create an immediate folder backup<\/p><\/blockquote><\/li>\n\n\n\n<li><blockquote class=\"wp-block-quote\"><p>Download backup<\/p><\/blockquote><\/li>\n\n\n\n<li><blockquote class=\"wp-block-quote\"><p>Restore a backup at the remote location<\/p><\/blockquote><\/li>\n<\/ol>\n\n\n\n<p>All one-click jobs, You don\u2019t need to learn Linux, you don\u2019t need to become a techie, moreover, you are notified for all of your clicks.<\/p>\n\n\n\n<p>It\u2019s simple to learn, you don\u2019t need to go through several videos or documents.<\/p>\n\n\n\n<p>Our Plugin: OBR ( <strong>Outright Backup and Restore<\/strong>) is a custom plugin developed by Outright Store, which makes this whole process automatic, a well-managed UI built on SuiteCRM makes everything automatic.<\/p>\n\n\n\n<p>Beloving Automation: &nbsp;At <em><strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Outright Store (opens in a new tab)\">Outright Store<\/a><\/strong><\/em>, we are a team of we are growing developer and QA. We work to make things better. We highly believe in Automation.<\/p>\n\n\n\n<p>OBR will be working easly on both <strong>Linux and Windows <\/strong>operating systems. It works on any SugarCE fork like SuiteCRM, SpiceCRM, etc.<\/p>\n\n\n\n<p>For more details, <strong><a href=\"https:\/\/youtu.be\/V9YPgqR5L-E\" target=\"_blank\" rel=\"noopener\">videos<\/a><\/strong>, and <strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2018\/11\/outright-backup-and-restore-manager1-1.pdf\">documentation<\/a><\/strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2018\/11\/outright-backup-and-restore-manager1-1.pdf\"><strong> <\/strong><\/a>for this add-on, please <strong><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/product\/suitecrm-backup-restore-manager\/\">click here<\/a><\/strong>.<\/p>\n\n\n\n<br\/>\n\n\n\n<p><strong>Related Post:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/importance-of-database-backup-for-crm-systems\/\" target=\"_blank\" rel=\"noreferrer noopener\">The Importance of Database Backup for CRM Systems<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automation of Backup and Restore of MySQL Databases Using SuiteCRM or SugarCRM<br \/>\nSo you are into a business!, which runs on crucial data, data manipulated the whole day. It does not matter how big you are, data is important.<\/p>\n","protected":false},"author":31,"featured_media":44840,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[55],"tags":[],"class_list":["post-1580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-suitecrm"],"acf":[],"_links":{"self":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/1580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/comments?post=1580"}],"version-history":[{"count":2,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/1580\/revisions"}],"predecessor-version":[{"id":60208,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/1580\/revisions\/60208"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media\/44840"}],"wp:attachment":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media?parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/categories?post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/tags?post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}