{"id":343,"date":"2011-10-18T16:47:38","date_gmt":"2011-10-18T14:47:38","guid":{"rendered":"http:\/\/webpiraten.de\/?p=343"},"modified":"2012-01-22T20:26:51","modified_gmt":"2012-01-22T19:26:51","slug":"ant-task-mysqldump-mit-gzip","status":"publish","type":"post","link":"https:\/\/webpiraten.de\/index.php\/mysql\/ant-task-mysqldump-mit-gzip\/","title":{"rendered":"ant task – mysqldump mit gzip"},"content":{"rendered":"

um mit ant einen gezipten mysqldump zu erstellen, gehe wie folgt vor<\/p>\n

\r\n    <target name="tstamp" description="create timestamp for further usage">\r\n        <echo message="create timestamp for further usage"\/>\r\n        <tstamp\/>\r\n    <\/target>\r\n\r\n    <target name="mkdir" description="create backup directory">\r\n        <echo message="create backup directory"\/>\r\n        <mkdir dir="${backups}"\/>\r\n    <\/target>\r\n\r\n    <target name="dump" description="create db dump and gzip it - depends on tstamp, mkdir" depends="tstamp, mkdir">\r\n        <echo message="create db dump and gzip it"\/>\r\n        <exec executable="bash" dir="${backups}">\r\n            <arg value="-c"\/>\r\n            <arg line='"mysqldump ${db} -u${db_user} -p${db_pass} | gzip > ${backups}\/${db}_${DSTAMP}_${TSTAMP}.sql.gz"'\/>\r\n        <\/exec>\r\n    <\/target>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
um mit ant einen gezipten mysqldump zu erstellen, gehe wie folgt vor <target name="tstamp" description="create timestamp for further usage"> <echo message="create timestamp for further usage"\/> <tstamp\/> <\/target> <target name="mkdir" description="create backup directory"> <echo message="create backup directory"\/> <mkdir dir="${backups}"\/> <\/target> <target name="dump" description="create db dump and gzip it – depends on tstamp, mkdir" depends="tstamp, mkdir"> <echo […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[78,56,77,75,11,54,76,79],"tags":[647,206,157,271,97,193,207,285],"class_list":["post-343","post","type-post","status-publish","format-standard","hentry","category-ant","category-apache","category-deployment","category-linux","category-mysql","category-server","category-shell","category-xml","tag-ant","tag-build","tag-gzip","tag-mysqldump","tag-pipe","tag-target","tag-task","tag-zip"],"_links":{"self":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/comments?post=343"}],"version-history":[{"count":2,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/343\/revisions"}],"predecessor-version":[{"id":352,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/343\/revisions\/352"}],"wp:attachment":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/media?parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/categories?post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/tags?post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}