{"id":92,"date":"2015-11-17T15:13:02","date_gmt":"2015-11-17T15:13:02","guid":{"rendered":"http:\/\/blog.datentraeger.li\/?p=92"},"modified":"2017-02-24T13:47:31","modified_gmt":"2017-02-24T13:47:31","slug":"mysql-search-replace","status":"publish","type":"post","link":"https:\/\/blog.datentraeger.li\/?p=92","title":{"rendered":"MySQL Search &#038; Replace"},"content":{"rendered":"<p>Nach einer Migration von Windows AD auf Samba4 hatte ich eine DB, die noch mit vielen alten DNs best\u00fcckt war. Das l\u00e4sst sich aber mit einem Query ganz bequem anpassen:<\/p>\n<pre class=\"wrap:true lang:sh decode:true \">mysql&gt; UPDATE ldap_users SET ldap_dn = replace(ldap_dn, \"ou=Users,dc=neuedomain,dc=local\", \"ou=Benutzer,dc=altedomain,dc=local\");\r\nQuery OK, 28 rows affected (0.00 sec)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Nach einer Migration von Windows AD auf Samba4 hatte ich eine DB, die noch mit vielen alten DNs best\u00fcckt war. Das l\u00e4sst sich aber mit einem Query ganz bequem anpassen: mysql&gt; UPDATE ldap_users SET ldap_dn = replace(ldap_dn, &#8220;ou=Users,dc=neuedomain,dc=local&#8221;, &#8220;ou=Benutzer,dc=altedomain,dc=local&#8221;); Query OK, 28 rows affected (0.00 sec)\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,16],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=92"}],"version-history":[{"count":2,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":467,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/92\/revisions\/467"}],"wp:attachment":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}