{"description":"\u4f5c\u696d\u4e2d\u306b\u7a3c\u50cd\u3057\u3066\u3044\u308bDB\u304b\u3089select\u30e6\u30fc\u30b6\u3067dump\u3057\u3088\u3046\u3068\u3057\u305f\u3089\u6012\u3089\u308c\u305f\u3002 MyISAM\u306a\u3089\u554f\u984c\u306a\u3044\u3093\u3060\u308d\u3046\u3051\u3069\u3001InnoDB\u3060\u3068transaction\u306e\u95a2\u4fc2\u3067\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u3055\u308c\u3066\u308b\u3068\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3057\u307e\u3046\u3002 Got error: 1044: Access denied for user 'select_user'@'localhost' to database 'dbname' when using LOCK TABLES \u8abf\u3079\u3066\u305f\u3089\u3053\u308c\u3067\u89e3\u6c7a\u3067\u304d\u305d\u3046\u3002 7.11. mysqldump \u2014 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d7\u30ed\u30b0\u30e9\u30e0 \u629c\u7c8b --single-transaction \u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u2026","type":"rich","provider_name":"Hatena Blog","author_name":"deadcode","version":"1.0","title":"\u3010MySQL\u3011 mysqldump\u3057\u3088\u3046\u3068\u3057\u305f\u3089  \u300c when doing LOCK TABLES \u300d\u3067dump\u3067\u304d\u306a\u3044","author_url":"https://blog.hatena.ne.jp/deadcode/","image_url":null,"width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdeadcode.hatenablog.jp%2Fentry%2F2014%2F05%2F08%2F223627\" title=\"\u3010MySQL\u3011 mysqldump\u3057\u3088\u3046\u3068\u3057\u305f\u3089  \u300c when doing LOCK TABLES \u300d\u3067dump\u3067\u304d\u306a\u3044 - \u65c5\u3059\u308b\u3048\u3093\u3058\u306b\u3042 - Engineers to Travel -\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://deadcode.hatenablog.jp/entry/2014/05/08/223627","published":"2014-05-08 22:36:27","height":"190","provider_url":"https://hatena.blog","categories":["MySQL"],"blog_url":"https://deadcode.hatenablog.jp/","blog_title":"\u65c5\u3059\u308b\u3048\u3093\u3058\u306b\u3042 - Engineers to Travel -"}