{"title":" \u30c8\u30ea\u30ac\u30fc\u4e00\u89a7\u8868\u793a","height":"190","provider_name":"Hatena Blog","width":"100%","author_name":"iww","published":"2016-04-04 00:00:00","image_url":null,"provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/iww/","categories":["MySQL"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fiww.hateblo.jp%2Fentry%2F20160404%2Ftriggers\" title=\" \u30c8\u30ea\u30ac\u30fc\u4e00\u89a7\u8868\u793a - \u63ee\u767a\u6027\u306e\u30e1\u30e2\uff12\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u63ee\u767a\u6027\u306e\u30e1\u30e2\uff12","blog_url":"https://iww.hateblo.jp/","version":"1.0","url":"https://iww.hateblo.jp/entry/20160404/triggers","description":"\u30c8\u30ea\u30ac\u30fc\u540d\u3001\u30a4\u30d9\u30f3\u30c8\u3001\u5bfe\u8c61\u30c6\u30fc\u30d6\u30eb \u306e\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b mysql -uUSERID -pPASSWD DBNAME -e \"SHOW TRIGGERS;\" -N | cut -f1,2,3 \u5168\u3066\u306e\u30c8\u30ea\u30ac\u30fc\u3092\u4e00\u62ec\u3067\u4fdd\u5b58\u3059\u308b mysqldump -ntd -uUSERID -pPASSWD DBNAME --tab=/tmp/triggers find /tmp/triggers -size 0 -delete \u4e00\u5fdc\u30c6\u30fc\u30d6\u30eb\u3054\u3068\u306b\u5206\u3051\u3066\u51fa\u529b\u3059\u308b \u305f\u3060\u30c8\u30ea\u30ac\u306e\u7121\u3044\u30c6\u30fc\u30d6\u30eb\u3082\u7a7a\u30d5\u30a1\u30a4\u30eb\u3067\u51fa\u529b\u3055\u308c\u3061\u3083\u3046\u306e\u3067\u3001\u9069\u5f53\u306b\u524a\u9664\u3059\u308b","type":"rich"}