{"blog_title":"k.saeki note","author_url":"https://blog.hatena.ne.jp/ch-saeki/","published":"2022-01-31 14:54:26","height":"190","provider_url":"https://hatena.blog","title":"MySQL\u3067db\u306e\u30b9\u30ad\u30fc\u30de\u306e\u5dee\u5206\u3092\u6bd4\u8f03\u3057\u305f\u3044.","description":"\u958b\u767a\u7528\u30d6\u30e9\u30f3\u30c1\u3092\u4f7f\u3063\u3066\u3044\u308b\u30c6\u30b9\u30c8\u74b0\u5883\u3067\u3001migrate\u306b\u5931\u6557\u3057\u305f\u6642\u306b\u624b\u52d5\u89e3\u6c7a(schema_migrations\u3092\u3044\u3058\u3044\u3058\u3068\u304b)\u3057\u305f\u305b\u3044\u3067\u3001\u521d\u56demigrate\u6642\u3068\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u30ea\u30b9\u30c8\u30a2\u3057\u305fdb\u3067\u5dee\u5206\u304c\u51fa\u3066\u3057\u307e\u3063\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u30b9\u30ad\u30fc\u30de\u3060\u3051\u6bd4\u8f03\u3057\u305f\u304f\u306a\u3063\u305f\u3002 sql\u306ediff\u7528\u306e\u30c4\u30fc\u30eb\u3068\u304b\u3082\u3042\u308b\u304c\u7d50\u5c40\u4ee5\u4e0b\u306e\u65b9\u6cd5\u3067dump\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u308b\u306e\u304c\u4e00\u756a\u65e9\u304b\u3063\u305f\u3002\u4fee\u6b63\u306f\u624b\u4f5c\u696d\u306b\u306a\u308b\u304c\u4ed5\u65b9\u3042\u308b\u307e\u3044\u3002 mysqldump -u user -p passwd -h 127.0.0.1 --all-databases --no-data --skip-create-options > schema_dump.\u2026","provider_name":"Hatena Blog","type":"rich","author_name":"ch-saeki","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fch-saeki.hatenadiary.com%2Fentry%2F2022%2F01%2F31%2F145426\" title=\"MySQL\u3067db\u306e\u30b9\u30ad\u30fc\u30de\u306e\u5dee\u5206\u3092\u6bd4\u8f03\u3057\u305f\u3044. - k.saeki note\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://ch-saeki.hatenadiary.com/","version":"1.0","categories":[],"image_url":null,"url":"https://ch-saeki.hatenadiary.com/entry/2022/01/31/145426"}