\u201cA Backup as Revolutionary as You Are.\u201d Ever heard that phrase before? If you did, you\u2019re no stranger to Zmanda Recovery Manager \u2013 or ZRM for short. Zmanda Recovery Manager is a terabyte-scale backup tool helping you take MySQL backups with ease, scalability, and without downtime \u2013 today we\u2019re telling you all about it and other backup tools specific to MySQL that you might not have heard about. Excited? We are too. Let\u2019s go!<\/p>\n
As already mentioned, Zmanda Recovery Manager (or ZRM for short) is a member of the Zmanda family of products \u2013 Zmanda is famous for offering backup tools for MySQL and MariaDB. The company allows its customers to scale up without any issues (they offer a pay-as-you-go subscription model), and its tools are capable to back up terabytes of data in MySQL.<\/p>\n
ZRM for MySQL solves various problems faced by MySQL DBAs:<\/p>\n
Zmanda\u2019s GUI lets its users choose what they want to backup, where they want their backups to be stored, and how the backups are supposed to be taken, however, before working with ZRM, users need to install it \u2013 doing so isn\u2019t very difficult though, and if you follow the steps outlined in the video made by the team<\/a>, you should be good to go.<\/p>\n As far as ZRM goes, though, it\u2019s not without its flaws \u2013 one of its drawbacks is that the tool is enterprise-grade, and even though it offers its users a free trial, seasoned software engineers will tell you that enterprise-grade software, security, and backup solutions are far from the cheapest \u2013 if you don\u2019t want to shell out thousands for a backup solution, other tools can help.<\/p>\n Aside from enterprise-grade weapons directed at backing our most precious data, there are other kinds of options, too.<\/p>\n One of those options is called SQL Backup and FTP<\/a> \u2013 a solution that\u2019s built to be very simple to use and looks like this<\/a> (the image is an example provided by SQLBackupandFTP.)<\/p>\n As far as this tool is concerned, everything is all pretty self-explanatory:<\/p>\n If we wish, we can also schedule our backups (see \u201cSchedule backups\u201d), and then we need to run the backup job (click the button in the upper right corner.) Once our backup would be finished, it would be stored in the specified directory \u2013 as easy as that.<\/p>\n Bear in mind that while SQL Backup and FTP does what it\u2019s advertised for and is quite powerful at its backup operations, it\u2019s ill-equipped to handle bigger and more complex workloads \u2013 for that, you would need to turn to SQLBak<\/a>.<\/p>\n SQLBak works similarly to SQL Backup and FTP, but it has a couple of extra features as well \u2013 it can take both full and incremental backups, restore backups, as well as send the confirmation of successful backups to a specified email address. The tool looks like this<\/a> (image from SQLBak).<\/p>\n As you might be able to tell, the tool has a couple of extra features SQLBackupandFTP does not including, but not limited to giving its users the ability to specify multiple destinations the backup is going to be stored in, giving its users the ability to compress and encrypt its backups with the strongest algorithm on the market, etc.<\/p>\n The rest of the features is up to you to explore!<\/p>\n In the last blog of our backup series, we have walked you through a couple of additional backup tools available to MySQL DBAs \u2013 while some of the backup tools (ZRM) that were shown were enterprise-grade only, we have also provided a couple of well-known alternatives.<\/p>\n <\/a> With that, our backup series is effectively over \u2013 we hope that you\u2019ve enjoyed reading the blog, let us know what you think in the comment section down below, come back to our blog for more interesting content related to database backups, security, and performance<\/a>, and until next time!<\/p>\n","protected":false},"excerpt":{"rendered":" In this blog, we’re walking you through one of the most popular MySQL backup tools – ZRM – and a couple of others. Have a read!…<\/p>\n","protected":false},"author":339547,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[146040],"class_list":["post-95200","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/339547"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=95200"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions"}],"predecessor-version":[{"id":95203,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions\/95203"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=95200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=95200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=95200"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=95200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Other Backup Software for MySQL<\/h2>\n
SQL Backup and FTP<\/h3>\n
\n
SQLBak<\/h3>\n
Summary<\/h2>\n
![this<\/a> (the image is an example provided by SQLBackupandFTP.)<\/p>\nAs far as this tool is concerned, everything is all pretty self-explanatory:<\/p>\n\nWe need to connect to our MySQL server (see \u201cConnect to MySQL Server.\u201d)<\/li>\nOnce the server is specified, we need to specify the databases that we\u2019re going to back up (\u201cSelect databases.\u201d)<\/li>\nOnce that\u2019s done, we select where we want to store the databases (\u201cStore backups in selected destinations\u201d), and whether we want to receive a confirmation once the backup is done (\u201cSend confirmation.\u201d)<\/li>\n<\/ol>\nIf we wish, we can also schedule our backups (see \u201cSchedule backups\u201d), and then we need to run the backup job (click the button in the upper right corner.) Once our backup would be finished, it would be stored in the specified directory \u2013 as easy as that.<\/p>\nBear in mind that while SQL Backup and FTP does what it\u2019s advertised for and is quite powerful at its backup operations, it\u2019s ill-equipped to handle bigger and more complex workloads \u2013 for that, you would need to turn to SQLBak<\/a>.<\/p>\nSQLBak<\/h3>\nSQLBak works similarly to SQL Backup and FTP, but it has a couple of extra features as well \u2013 it can take both full and incremental backups, restore backups, as well as send the confirmation of successful backups to a specified email address. The tool looks like this<\/a> (image from SQLBak).<\/p>\nAs you might be able to tell, the tool has a couple of extra features SQLBackupandFTP does not including, but not limited to giving its users the ability to specify multiple destinations the backup is going to be stored in, giving its users the ability to compress and encrypt its backups with the strongest algorithm on the market, etc.<\/p>\nThe rest of the features is up to you to explore!<\/p>\nSummary<\/h2>\nIn the last blog of our backup series, we have walked you through a couple of additional backup tools available to MySQL DBAs \u2013 while some of the backup tools (ZRM) that were shown were enterprise-grade only, we have also provided a couple of well-known alternatives.<\/p>\n<\/a> With that, our backup series is effectively over \u2013 we hope that you\u2019ve enjoyed reading the blog, let us know what you think in the comment section down below, come back to our blog for more interesting content related to database backups, security, and performance<\/a>, and until next time!<\/p>\n","protected":false},"excerpt":{"rendered":"In this blog, we’re walking you through one of the most popular MySQL backup tools – ZRM – and a couple of others. Have a read!…<\/p>\n","protected":false},"author":339547,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[146040],"class_list":["post-95200","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/339547"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=95200"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions"}],"predecessor-version":[{"id":95203,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions\/95203"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=95200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=95200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=95200"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=95200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/sqlbackupandftp.com\/Content\/landing\/img\/animation-mysbf\/main-5.png\"){kind=link}
![this<\/a> (image from SQLBak).<\/p>\nAs you might be able to tell, the tool has a couple of extra features SQLBackupandFTP does not including, but not limited to giving its users the ability to specify multiple destinations the backup is going to be stored in, giving its users the ability to compress and encrypt its backups with the strongest algorithm on the market, etc.<\/p>\nThe rest of the features is up to you to explore!<\/p>\nSummary<\/h2>\nIn the last blog of our backup series, we have walked you through a couple of additional backup tools available to MySQL DBAs \u2013 while some of the backup tools (ZRM) that were shown were enterprise-grade only, we have also provided a couple of well-known alternatives.<\/p>\n<\/a> With that, our backup series is effectively over \u2013 we hope that you\u2019ve enjoyed reading the blog, let us know what you think in the comment section down below, come back to our blog for more interesting content related to database backups, security, and performance<\/a>, and until next time!<\/p>\n","protected":false},"excerpt":{"rendered":"In this blog, we’re walking you through one of the most popular MySQL backup tools – ZRM – and a couple of others. Have a read!…<\/p>\n","protected":false},"author":339547,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[146040],"class_list":["post-95200","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/339547"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=95200"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions"}],"predecessor-version":[{"id":95203,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/95200\/revisions\/95203"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=95200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=95200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=95200"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=95200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/sqlbak.com\/assets\/images\/content\/lp3\/how-2.png\"){kind=link}