{"id":6090,"date":"2021-01-30T15:41:46","date_gmt":"2021-01-30T10:11:46","guid":{"rendered":"https:\/\/blog.pheonixsolutions.com\/?p=6090"},"modified":"2021-02-01T17:51:55","modified_gmt":"2021-02-01T12:21:55","slug":"automate-mysqldump-backup-from-serverbackend-to-amazon-s3","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/","title":{"rendered":"Automate MySQLdump Backup from server(backend) to Amazon S3"},"content":{"rendered":"\n

Please follow the below steps to setup backup of mysql database from server to Amazon s3.<\/p>\n\n\n\n

  1. Login to AWS console, create IAM user, download the credentials and attach AmazonS3Full access policy to the IAM user.<\/li>
  2. Install AWS CLI and configure by following the below commands.
    apt install awscli -y
    aws configure<\/span><\/li>
  3. It will ask for Access Id and secret key. Provide the same which we downloaded in step-1 and proceed.<\/li>
  4. Verify AWS S3 list by following the below command.
    aws s3 ls<\/span><\/li>
  5. Install S3fs and Mount S3 Bucket by following the below commands.
    apt install s3fs<\/span>
    echo ACCESS_KEY_ID:SECRET_ACCESS_KEY > \/home\/ubuntu\/.s3fs- creds<\/span><\/li>
  6. Your file will be saved at \/home\/ubuntu\/.s3fs-creds.<\/span><\/li>
  7. chmod 600 \/home\/ubuntu\/.s3fs-creds<\/span><\/li>
  8. Create a new folder from your home directory.
    mkdir \/home\/ubuntu\/s3_uploads<\/span><\/li>
  9. Create an Automation Backup Script for MySQLdump
    vim \/home\/ubuntu\/.config.cnf<\/span><\/li>
  10. Add the following below:
    [client]
    user = dbuser
    password = dbpassword
    host = localhost<\/span>
    Save and close the file.<\/li>
  11. create an automation backup script for MySQLdump
    vim \/home\/ubuntu\/mysqldump.sh<\/span><\/li>
  12. Add the following script
    !\/bin\/bash
    DBNAME=yourdbname
    BACKUP=\/home\/ubuntu\/s3_uploads
    Backup date
    date=$(date +’%Y%m%d%H%M%S’);
    Start exec backup..
    mysqldump –defaults-extra-file=\/home\/ubuntu\/.config.cnf $DBNAME > $BACKUP\/mysqldump_$date.sql<\/span><\/li>
  13. Save and close the file.<\/li>
  14. To make sure the file is executable, run the below command.
    chmod +x \/home\/ubuntu\/mysqldump.sh<\/span><\/li>
  15. To automate your backup, use to command below to assign the mysql dump script on cron scheduling jobs.
    crontab -e<\/span><\/li>
  16. If your first time to open the crontab, you can choose the vim editor on the screen and then add the following command to the bottom line.
    @daily sh \/home\/ubuntu\/mysqldump.sh<\/span><\/li>
  17. Save and close the file.<\/li>
  18. Testing MySQLdump to S3 Bucket<\/li>
  19. Go to the directory where mysqldump.sh is located and run the script.
    .\/mysqldump.sh<\/span><\/li>
  20. After the backups completes, open the mounted s3_uploads<\/code> folder and type the below command.
    ls -lah<\/span><\/li>
  21. On the screen, you can see the files which were uploaded.<\/li>
  22. Verify the files on S3 Bucket Console.
    <\/li><\/ol>\n\n\n\n

    <\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Please follow the below steps to setup backup of mysql database from server to Amazon s3. Login to AWS console, create IAM user, download the credentials and attach AmazonS3Full access policy to the IAM user. Install AWS CLI and configure by following the below commands. apt install awscli -y aws… Continue Reading Automate MySQLdump Backup from server(backend) to Amazon S3<\/span><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[270],"tags":[300,813,812,324],"class_list":{"0":"post-6090","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-amazon","7":"tag-aws","8":"tag-backup-of-mysql-databse-to-s3","9":"tag-mysql-dump-to-s3","10":"tag-s3","11":"h-entry","13":"h-as-article"},"yoast_head":"\nPheonix Solutions - We Empower Your Business Growth<\/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:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pheonix Solutions - We Empower Your Business Growth\" \/>\n<meta property=\"og:description\" content=\"Please follow the below steps to setup backup of mysql database from server to Amazon s3. Login to AWS console, create IAM user, download the credentials and attach AmazonS3Full access policy to the IAM user. Install AWS CLI and configure by following the below commands. apt install awscli -y aws… Continue Reading Automate MySQLdump Backup from server(backend) to Amazon S3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/\" \/>\n<meta property=\"og:site_name\" content=\"PHEONIXSOLUTIONS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-30T10:11:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-01T12:21:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3837\" \/>\n\t<meta property=\"og:image:height\" content=\"2540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:site\" content=\"@pheonixsolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\"},\"headline\":\"Automate MySQLdump Backup from server(backend) to Amazon S3\",\"datePublished\":\"2021-01-30T10:11:46+00:00\",\"dateModified\":\"2021-02-01T12:21:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/\"},\"wordCount\":353,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"keywords\":[\"aws\",\"backup of mysql databse to s3\",\"mysql dump to s3\",\"s3\"],\"articleSection\":[\"Amazon\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/\",\"name\":\"Pheonix Solutions - We Empower Your Business Growth\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-01-30T10:11:46+00:00\",\"dateModified\":\"2021-02-01T12:21:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automate MySQLdump Backup from server(backend) to Amazon S3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"name\":\"Pheonix Solutions\",\"description\":\"We Empower Your Business Growth\",\"publisher\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#organization\",\"name\":\"PheonixSolutions\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/logo.png\",\"width\":454,\"height\":300,\"caption\":\"PheonixSolutions\"},\"image\":{\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PheonixSolutions-209942982759387\\\/\",\"https:\\\/\\\/x.com\\\/pheonixsolution\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/#\\\/schema\\\/person\\\/0ffa33d73c869faec2d50e79c24e3503\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/blog.pheonixsolutions.com\"],\"url\":\"https:\\\/\\\/pheonixsolutions.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pheonix Solutions - We Empower Your Business Growth","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:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/","og_locale":"en_US","og_type":"article","og_title":"Pheonix Solutions - We Empower Your Business Growth","og_description":"Please follow the below steps to setup backup of mysql database from server to Amazon s3. Login to AWS console, create IAM user, download the credentials and attach AmazonS3Full access policy to the IAM user. Install AWS CLI and configure by following the below commands. apt install awscli -y aws… Continue Reading Automate MySQLdump Backup from server(backend) to Amazon S3","og_url":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/","og_site_name":"PHEONIXSOLUTIONS","article_publisher":"https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","article_published_time":"2021-01-30T10:11:46+00:00","article_modified_time":"2021-02-01T12:21:55+00:00","og_image":[{"width":3837,"height":2540,"url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/09\/PX2.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@pheonixsolution","twitter_site":"@pheonixsolution","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/#article","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/"},"author":{"name":"admin","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503"},"headline":"Automate MySQLdump Backup from server(backend) to Amazon S3","datePublished":"2021-01-30T10:11:46+00:00","dateModified":"2021-02-01T12:21:55+00:00","mainEntityOfPage":{"@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/"},"wordCount":353,"commentCount":0,"publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"keywords":["aws","backup of mysql databse to s3","mysql dump to s3","s3"],"articleSection":["Amazon"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/","url":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/","name":"Pheonix Solutions - We Empower Your Business Growth","isPartOf":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#website"},"datePublished":"2021-01-30T10:11:46+00:00","dateModified":"2021-02-01T12:21:55+00:00","breadcrumb":{"@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pheonixsolutions.com\/blog\/automate-mysqldump-backup-from-serverbackend-to-amazon-s3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pheonixsolutions.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Automate MySQLdump Backup from server(backend) to Amazon S3"}]},{"@type":"WebSite","@id":"https:\/\/pheonixsolutions.com\/blog\/#website","url":"https:\/\/pheonixsolutions.com\/blog\/","name":"Pheonix Solutions","description":"We Empower Your Business Growth","publisher":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pheonixsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pheonixsolutions.com\/blog\/#organization","name":"PheonixSolutions","url":"https:\/\/pheonixsolutions.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","contentUrl":"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/logo.png","width":454,"height":300,"caption":"PheonixSolutions"},"image":{"@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PheonixSolutions-209942982759387\/","https:\/\/x.com\/pheonixsolution"]},{"@type":"Person","@id":"https:\/\/pheonixsolutions.com\/blog\/#\/schema\/person\/0ffa33d73c869faec2d50e79c24e3503","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09bacc0294abee1322a23ab4bc6a0330dd4cb4df707dc9d0b0efeba6c109608b?s=96&r=g","caption":"admin"},"sameAs":["http:\/\/blog.pheonixsolutions.com"],"url":"https:\/\/pheonixsolutions.com\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7F4uM-1Ae","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6090"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6090\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}