{"id":18090,"date":"2015-11-17T15:35:06","date_gmt":"2015-11-17T21:35:06","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=18090"},"modified":"2022-06-03T03:44:03","modified_gmt":"2022-06-03T08:44:03","slug":"how-to-install-and-configure-automysqlbackup","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/","title":{"rendered":"How to install and configure AutoMySQLBackup"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-25164\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg\" alt=\"How to install and configure AutoMySQLBackup\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg 1200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-768x384.jpg 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-1024x512.jpg 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-860x430.jpg 860w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-680x340.jpg 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-500x250.jpg 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-400x200.jpg 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-200x100.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup-50x25.jpg 50w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p>we&#8217;ll show you, how to install AutoMySQLBackup on a Linux VPS. AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or more MySQL databases from one of more MySQL servers. It dumps the databases and compress them in to archives.<!--more-->it comes with many features such as:<\/p>\n<ul>\n<li>\u00a0 Email notification of backups<\/li>\n<li>\u00a0 Backup Compression and Encryption<\/li>\n<li>\u00a0 Configurable backup rotation<\/li>\n<li>\u00a0 Incremental database backups<\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69faa18626f2a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69faa18626f2a\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#1-Login-via-SSH\" >1. Login via SSH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#2-Update-the-System\" >2. Update the System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#3-On-Debian-based-distributions-AutoMySQLBackup-is-available-in-the-repositories\" >3. On Debian based distributions AutoMySQLBackup is available in the repositories<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#4-On-RPM-based-distributions-you-will-have-to-download-AutoMySQLBackup\" >4. On RPM based distributions you will have to download AutoMySQLBackup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#5-Download-AutoMySQLBackup\" >5. Download\u00a0AutoMySQLBackup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#6-Install-AutoMySQLBackup\" >6. Install\u00a0AutoMySQLBackup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#7-Configure-AutoMySQLBackup\" >7. Configure\u00a0AutoMySQLBackup<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Login-via-SSH\"><\/span>1. Login via SSH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As usual, log in to your server as user root<\/p>\n<pre>ssh root@IP<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"2-Update-the-System\"><\/span>2. Update the System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>and execute the following command to make sure that all services ar up to date<\/p>\n<p>For Debian based systems execute<\/p>\n<pre>apt-get update &amp;&amp; apt-get upgrade<\/pre>\n<p>For RPM based systems execute<\/p>\n<pre>yum -y update<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-On-Debian-based-distributions-AutoMySQLBackup-is-available-in-the-repositories\"><\/span>3. On Debian based distributions AutoMySQLBackup is available in the repositories<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you are running Debian based distro AutoMySQLBackup is available in the repositories and you can easily install it by executing the following<\/p>\n<pre>apt-get install automysqlbackup<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"4-On-RPM-based-distributions-you-will-have-to-download-AutoMySQLBackup\"><\/span>4. On RPM based distributions you will have to download AutoMySQLBackup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a RPM based distro you will have to download AutoMySQLBackup&#8217;s installation scripts, run and configure them on your server. In this tutorial we will install Automysqlbackup on a CentOS 7 VPS.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"5-Download-AutoMySQLBackup\"><\/span>5. Download\u00a0AutoMySQLBackup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Download the latest version of AutoMySQLBackup to your server<\/p>\n<pre>wget http:\/\/downloads.sourceforge.net\/project\/automysqlbackup\/AutoMySQLBackup\/AutoMySQLBackup%20VER%203.0\/automysqlbackup-v3.0_rc6.tar.gz<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"6-Install-AutoMySQLBackup\"><\/span>6. Install\u00a0AutoMySQLBackup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Create a directory for Automysqlbackup&#8217;s scripts and unpack the downloaded tar archive<\/p>\n<pre>mkdir \/opt\/automysqlbackup\r\ntar zxvf automysqlbackup-v3.0_rc6.tar.gz -C \/opt\/automysqlbackup<\/pre>\n<p>Once the archive is unpacked run the Automysqlbackup installation script<\/p>\n<pre>cd \/opt\/automysqlbackup\r\n.\/install.sh\r\n\r\n### Checking archive files for existence, readability and integrity.\r\n\r\nautomysqlbackup ... exists and is readable ... md5sum okay :)\r\nautomysqlbackup.conf ... exists and is readable ... md5sum okay :)\r\nREADME ... exists and is readable ... md5sum okay :)\r\nLICENSE ... exists and is readable ... md5sum okay :)\r\n\r\nSelect the global configuration directory [\/etc\/automysqlbackup]:\r\nSelect directory for the executable [\/usr\/local\/bin]:\r\n### Creating global configuration directory \/etc\/automysqlbackup:\r\n\r\nsuccess<\/pre>\n<p>You can use the default paths for the global configuration directory and the directory for the executable. You just have to press Enter when the paths are required.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"7-Configure-AutoMySQLBackup\"><\/span>7. Configure\u00a0AutoMySQLBackup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Next, we have to configure AutoMySQLBackup. Open its configuration file located in the directory we set when we ran the installation script.<\/p>\n<pre>vim \/etc\/automysqlbackup\/automysqlbackup.conf<\/pre>\n<p>And uncommend and set the following confituration directives<\/p>\n<pre>CONFIG_mysql_dump_username='root'\r\nCONFIG_mysql_dump_password='YourPassword'\r\nCONFIG_mysql_dump_host='localhost'\r\nCONFIG_backup_dir='\/var\/backup\/db'\r\nCONFIG_do_monthly=\"01\"\r\nCONFIG_do_weekly=\"5\"\r\nCONFIG_rotation_daily=6\r\nCONFIG_rotation_weekly=35\r\nCONFIG_rotation_monthly=150\r\nCONFIG_mysql_dump_port=3306\r\nCONFIG_mysql_dump_compression='gzip'<\/pre>\n<p>Once you are done with editing, save the configuration file. All settings are optional and there is description for all of them, so it is best to check the configuration file for more information about the settings of AutoMySQLBackup.<\/p>\n<p>Create a directory for the MySQL backups. This is the directory we set as &#8216;backup_dir&#8217; in the configuration file.<\/p>\n<pre>mkdir \/var\/backup<\/pre>\n<p>If you want to create a backup of your MySQL databases, run AutoMySQLBackup by executing the following<\/p>\n<pre>automysqlbackup<\/pre>\n<p>You can also create a crontab entry to run AutoMySQLBackup at a specific time.<\/p>\n<p>That&#8217;s all. You can check the README file for more information on how to use AutoMySQLBackup.<\/p>\n<p>Of course you don\u2019t have to install and configure AutoMySQLBackup, if you use one of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to install AutoMySQLBackup for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post, on how to install and configure AutoMySQLBackup, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>we&#8217;ll show you, how to install AutoMySQLBackup on a Linux VPS. AutoMySQLBackup is very useful utility for creating daily, weekly &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to install and configure AutoMySQLBackup\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#more-18090\" aria-label=\"Read more about How to install and configure AutoMySQLBackup\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":25164,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,13],"tags":[974,457,39],"class_list":["post-18090","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-tutorials","tag-automysqlbackup","tag-backup","tag-mysql","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to install and configure AutoMySQLBackup | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to install and configure AutoMySQLBackup | RoseHosting\" \/>\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.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install and configure AutoMySQLBackup\" \/>\n<meta property=\"og:description\" content=\"How to install and configure AutoMySQLBackup | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-17T21:35:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:44:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to install and configure AutoMySQLBackup\",\"datePublished\":\"2015-11-17T21:35:06+00:00\",\"dateModified\":\"2022-06-03T08:44:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/\"},\"wordCount\":478,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/How-to-install-and-configure-AutoMySQLBackup.jpg\",\"keywords\":[\"automysqlbackup\",\"backup\",\"mysql\"],\"articleSection\":[\"Databases\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/\",\"name\":\"How to install and configure AutoMySQLBackup | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/How-to-install-and-configure-AutoMySQLBackup.jpg\",\"datePublished\":\"2015-11-17T21:35:06+00:00\",\"dateModified\":\"2022-06-03T08:44:03+00:00\",\"description\":\"How to install and configure AutoMySQLBackup | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/How-to-install-and-configure-AutoMySQLBackup.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/How-to-install-and-configure-AutoMySQLBackup.jpg\",\"width\":1200,\"height\":600,\"caption\":\"How to install and configure AutoMySQLBackup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-and-configure-automysqlbackup\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install and configure AutoMySQLBackup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to install and configure AutoMySQLBackup | RoseHosting","description":"How to install and configure AutoMySQLBackup | RoseHosting","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.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/","og_locale":"en_US","og_type":"article","og_title":"How to install and configure AutoMySQLBackup","og_description":"How to install and configure AutoMySQLBackup | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2015-11-17T21:35:06+00:00","article_modified_time":"2022-06-03T08:44:03+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to install and configure AutoMySQLBackup","datePublished":"2015-11-17T21:35:06+00:00","dateModified":"2022-06-03T08:44:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/"},"wordCount":478,"commentCount":4,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg","keywords":["automysqlbackup","backup","mysql"],"articleSection":["Databases","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/","name":"How to install and configure AutoMySQLBackup | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg","datePublished":"2015-11-17T21:35:06+00:00","dateModified":"2022-06-03T08:44:03+00:00","description":"How to install and configure AutoMySQLBackup | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/11\/How-to-install-and-configure-AutoMySQLBackup.jpg","width":1200,"height":600,"caption":"How to install and configure AutoMySQLBackup"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-and-configure-automysqlbackup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to install and configure AutoMySQLBackup"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/18090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=18090"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/18090\/revisions"}],"predecessor-version":[{"id":42052,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/18090\/revisions\/42052"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/25164"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=18090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=18090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=18090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}