{"id":60,"date":"2009-06-19T07:58:35","date_gmt":"2009-06-19T14:58:35","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=60"},"modified":"2009-11-26T06:04:26","modified_gmt":"2009-11-26T13:04:26","slug":"windows-batch-para-respaldo","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2009\/06\/19\/windows-batch-para-respaldo\/","title":{"rendered":"Windows Batch para respaldo"},"content":{"rendered":"<p>Este es un archivo llamado backup.cmd que utilizo para respaldar una base de datos y el repositorio de subversion, estando programada para correr diariamente, primero extrae la fecha, crea una carpeta, y crea los backup dentro de la carpeta<\/p>\n<pre class=\"brush: shell\">FOR \/F \"TOKENS=1* DELIMS= \" %%A IN ('DATE\/T') DO SET CDATE=%%B\r\nFOR \/F \"TOKENS=1,2 eol=\/ DELIMS=\/ \" %%A IN ('DATE\/T') DO SET mm=%%B\r\nFOR \/F \"TOKENS=1,2 DELIMS=\/ eol=\/\" %%A IN ('echo %CDATE%') DO SET dd=%%B\r\nFOR \/F \"TOKENS=2,3 DELIMS=\/ \" %%A IN ('echo %CDATE%') DO SET yyyy=%%B\r\nSET date=%yyyy%%mm%%dd%\r\nmkdir d:\\backup\\%date%\r\nexp system\/password@SID file=d:\\backup\\%date%\\ora_esquema%date%.dmp owner=esquema\r\n\"C:\\Program Files (x86)\\VisualSVN Server\\bin\\svnadmin.exe\" dump D:\\SubVersionRepo\\proyecto &gt; d:\\backup\\%date%\\svn_proyecto%date%.dump<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Este es un archivo llamado backup.cmd que utilizo para respaldar una base de datos y el repositorio de subversion, estando programada para correr diariamente, primero extrae la fecha, crea una carpeta, y crea los backup dentro de la carpeta FOR \/F \u00abTOKENS=1* DELIMS= \u00bb %%A IN (&#8216;DATE\/T&#8217;) DO SET CDATE=%%B FOR \/F \u00abTOKENS=1,2 eol=\/ DELIMS=\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,9,13],"tags":[],"class_list":["post-60","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-oracle","category-windows"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/60"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":5,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions\/63"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}