{"id":622,"date":"2014-09-12T13:22:55","date_gmt":"2014-09-12T04:22:55","guid":{"rendered":"http:\/\/matoken.org\/blog\/?p=622"},"modified":"2014-09-12T20:20:40","modified_gmt":"2014-09-12T11:20:40","slug":"mysqldump_warning_fix","status":"publish","type":"post","link":"https:\/\/matoken.org\/blog\/2014\/09\/12\/mysqldump_warning_fix\/","title":{"rendered":"mysqldump \u306e\u8b66\u544a\u3092\u4fee\u6b63(Warning: Using unique option prefix event instead of events is deprecated and will be removed in a future release. Please use the full name instead.)"},"content":{"rendered":"

mysql \u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u6642\u306b\u8b66\u544a\u304c\u51fa\u3066\u3044\u308b\u306e\u306b\u6c17\u3065\u304d\u307e\u3057\u305f\uff0e<\/p>\n

Warning: Using unique option prefix event instead of events is deprecated and will be removed in a future release. Please use the full name instead.<\/code><\/p>\n

\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u691c\u7d22\u3059\u308b\u3068\u3061\u3087\u3063\u3068\u524d\u306e\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8\u306b\u305d\u308c\u3089\u3057\u3044\u3082\u306e\u304c\uff0e<\/p>\n

\n

Previously, program options could be specified in full or as any unambiguous prefix. For example, the –compress option could be given to mysqldump as –compr, but not as –comp because the latter is ambiguous. Option prefixes now are deprecated. They can cause problems when new options are implemented for programs. A prefix that is currently unambiguous might become ambiguous in the future. If an unambiguous prefix is given, a warning now occurs to provide feedback. For example: Warning: Using unique option prefix compr instead of compress is deprecated and will be removed in a future release. Please use the full name instead. Option prefixes are no longer supported in MySQL 5.7; only full options are accepted. (Bug #16996656) MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.13 (2013-07-31)<\/a><\/p>\n<\/blockquote>\n

\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u7701\u7565\u3057\u305f\u308a\u3059\u308b\u3068\u8b66\u544a\u3092\u51fa\u3059\u3088\u3046\u306b\u306a\u3063\u305f\u3088\uff0e5.7\u304b\u3089\u4f7f\u3048\u306a\u304f\u306a\u308b\u3088\uff0e\u3068\u3044\u3046\u3053\u3068\u306e\u3088\u3046\u3067\u3059\uff0e<\/p>\n

\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306fssh \u7d4c\u7531\u306e\u30ea\u30e2\u30fc\u30c8\u3067\u53d6\u5f97\u3057\u3066\u3044\u3066\uff0c ~\/.ssh\/authorized_keys \u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u611f\u3058\u3067\u66f8\u3044\u3066\u3044\u307e\u3057\u305f\uff0e<\/p>\n

command=\"\/usr\/bin\/mysqldump --defaults-file=\/home\/user\/.my.cnf --opt --all-databases --event | \/usr\/bin\/xz -9\",from=\"nnn.nnn.nnn.nnn\",no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding ecdsa-sha2-nistp521 AAAA...<\/code><\/p>\n

–event \u90e8\u5206\u306f\u672c\u6765\u306f –events \u306e\u69d8\u306a\u306e\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4fee\u6b63\u3057\u3066\u89e3\u6c7a\u3057\u307e\u3057\u305f\uff0e<\/p>\n

command=\"\/usr\/bin\/mysqldump --defaults-file=\/home\/user\/.my.cnf --opt --all-databases --events | \/usr\/bin\/xz -9\",from=\"nnn.nnn.nnn.nnn\",no-pty,no-port-forwarding,no-X11-forwarding,no-agent-forwarding ecdsa-sha2-nistp521 AAAA...<\/code><\/p>\n

\uff03\u3061\u306a\u307f\u306b\u53d7\u3051\u5074\u306f\u3053\u3093\u306a\u611f\u3058 2 13 * * * \/usr\/bin\/ssh -q -p nnnnn -i \/home\/user\/.ssh\/id_ecdsa-mysql-backup user@server > \/backup\/server\/db\/&#96;\/bin\/date +\\%Y\\%M\\%d_\\%H:\\%m:\\%S_\\%s_$$&#96;.sql.xz`<\/code><\/p>\n