{"blog_title":"zuntan02\u306e\u306f\u3066\u306a\u30d6\u30ed\u30b0","version":"1.0","author_url":"https://blog.hatena.ne.jp/zuntan02/","provider_url":"https://hatena.blog","author_name":"zuntan02","blog_url":"https://zuntan02.hateblo.jp/","url":"https://zuntan02.hateblo.jp/entry/20140220/1392884448","published":"2014-02-20 17:20:48","title":"MySQL\u306e\u30c0\u30f3\u30d7\u3092\u4e16\u4ee3\u7ba1\u7406\u3059\u308b","type":"rich","categories":[],"provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fzuntan02.hateblo.jp%2Fentry%2F20140220%2F1392884448\" title=\"MySQL\u306e\u30c0\u30f3\u30d7\u3092\u4e16\u4ee3\u7ba1\u7406\u3059\u308b - zuntan02\u306e\u306f\u3066\u306a\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","height":"190","image_url":null,"description":"\u30fbCentOS \u30fb\u30d0\u30a4\u30ca\u30ea\u3067DB\u3054\u3068\u30c0\u30f3\u30d7 \u30fb1\u9031\u9593\u5206\u6b8b\u3057\u3066\u53e4\u3044\u306e\u3092\u6d88\u3059\u3002dbbackup.sh #!/bin/sh bak=`date +%Y%m%d` mysqldump --default-character-set=binary --hex-blob -c -u \u30e6\u30fc\u30b6\u540d -p\u30d1\u30b9\u30ef\u30fc\u30c9 testdb > /home/admin/_bkup/testdb.$bak.sql gzip /home/admin/_bkup/testdb.$bak.sql bak2=`date --date \"7 days ago\" +%Y%m%d` rm -f /home/admin/_bkup/testd\u2026"}