如何使用 Cron 选项卡每晚获取 MySQL 数据库备份并将其放入 Amazon s3 中? [英] How to take MySQL Database backup and put it in Amazon s3 every Night by using Cron tab?

问题描述

我在 Rackspace 有一台服务器，我已经在每天晚上运行 cron 作业来处理某些事情......(一些与帐户相关的操作 - 每半夜都会向我发送电子邮件).我的应用程序在 grails 上很流行.现在我想在每个午夜进行 mysql 数据库(称为 myfleet)备份并将该文件放在 Amezon S3 中.我怎样才能做到这一点?我是否需要编写任何 java 或 groovy 文件来处理它?还是可以从 Linux 机器本身完成?我已经在 Amezon S3 中获得了帐户(存储桶名称是fleetBucket)

I have got one server in Rackspace and i'm already running a cron job evry day night to process something...(some account related operation- that will send me email every mid night). my application is in groovy on grails. now i want to take mysql database (called myfleet) backup on every mid night and put that file in Amezon S3 . how can i do that? do i need to write any java or groovy file to process that? or is it can be done from Linux box itself? i have already got account in Amezon S3 (bucket name is fleetBucket)

推荐答案

应该很简单:
- 使用 mysqldump 备份您的数据库

Should be pretty straightforward:
- backup your database using mysqldump

mysqldump -u [uname] -p[pass] myfleet | gzip -9 > myfleet.sql.gz  

- 使用命令行客户端将您的转储文件上传到 S3(例如 http://s3tools.org/s3cmd:
s3cmd put myfleet.sql.gz s3:///myfleet.sql.gz

- upload your dump file to S3 using a command line client (e.g. http://s3tools.org/s3cmd:
s3cmd put myfleet.sql.gz s3://<bucketname>/myfleet.sql.gz

只需将此添加到您的 cron 作业中(您可能希望对转储文件使用某种编号方案，以防您想保留多个版本).

Just add this to your cron job (you might want to use some kind of numbering scheme for the dump files, in case you want to keep several versions).

这篇关于如何使用 Cron 选项卡每晚获取 MySQL 数据库备份并将其放入 Amazon s3 中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！