{"id":67,"date":"2016-02-29T21:51:54","date_gmt":"2016-02-29T20:51:54","guid":{"rendered":"http:\/\/debnar.org\/wp\/?p=67"},"modified":"2016-02-29T21:51:54","modified_gmt":"2016-02-29T20:51:54","slug":"mysql-takolas","status":"publish","type":"post","link":"https:\/\/debnar.org\/wp\/?p=67","title":{"rendered":"MySQL “t\u00e1kol\u00e1s”"},"content":{"rendered":"

Sikeresen vissz\u00e1ll\u00edtottam n\u00e9h\u00e1ny postot. (YAY) Nem \u00e9ppen tegnapi backup (5 \u00e9ves te j\u00f3 \u00e9g…), \u00e1m am\u00fagysem \u00edrk\u00e1ltam j\u00f3 ideje ide. Ha j\u00f3l eml\u00e9kszem egy Nagios poszt volt, valamivel sz\u00edvtam FreeBSD alatt… A l\u00e9nyeg, hogy nem \u00fcres az oldal \u00edgy legal\u00e1bb, illetve akkor r\u00f6gt\u00f6n le is \u00edrom, hogy \u00e1ll\u00edtsunk vissza “paraszt” backupb\u00f3l MySQL t\u00e1bl\u00e1kat.<\/p>\n

<\/p>\n

Mysqldump a gyerekeknek val\u00f3, igazi f\u00e9rfi az adatb\u00e1zis mapp\u00e1t lem\u00e1solja \u00e9s j\u00f3napot (ejj). Szerencs\u00e9re MyISAM-r\u00f3l k\u00e9sz\u00fclt \u00edgy ugyanabban a mapp\u00e1ba a t\u00e1bladefin\u00edci\u00f3k mellett voltak az adatok is (innodb-t most meg nem mondom hol t\u00e1rolja). Sz\u00f3val \u00e9n is \u00edgy j\u00e1rtam, r\u00e1ad\u00e1sul nem is egy mai wordpress\/mysql komb\u00f3r\u00f3l k\u00e9sz\u00fclt, de szerencs\u00e9re sim\u00e1n megette. El\u0151sz\u00f6r is m\u00e1soljuk be sim\u00e1n a lementett MYD f\u00e1jlunkat az FRM bar\u00e1tk\u00e1ja mell\u00e9:<\/p>\n

# cp wp_posts.MYD\u00a0\/var\/lib\/mysql\/wordpress\/wp_posts.MYD
\nchown mysql:mysql \/var\/lib\/mysql\/wordpress\/wp_posts.MYD<\/p><\/blockquote>\n

Majd adjunk neki a mysql konzolb\u00f3l<\/p>\n

mysql>\u00a0ALTER TABLE wordpress.wp_posts ENGINE=MyISAM;
\nmysql> repair table wordpress.wp_posts;<\/p><\/blockquote>\n

\u00c9s meg is vagyunk. J\u00f3l beposztosodik a blogunk. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

Sikeresen vissz\u00e1ll\u00edtottam n\u00e9h\u00e1ny postot. (YAY) Nem \u00e9ppen tegnapi backup (5 \u00e9ves te j\u00f3 \u00e9g…), \u00e1m am\u00fagysem \u00edrk\u00e1ltam j\u00f3 ideje ide. Ha j\u00f3l eml\u00e9kszem egy Nagios poszt volt, valamivel sz\u00edvtam FreeBSD alatt… A l\u00e9nyeg, hogy nem \u00fcres az oldal \u00edgy legal\u00e1bb, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":1,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debnar.org\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}