{"id":2343,"date":"2010-12-14T00:36:17","date_gmt":"2010-12-13T19:06:17","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=2343"},"modified":"2016-12-19T15:06:35","modified_gmt":"2016-12-19T09:36:35","slug":"database-backup-script-for-windows","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/database-backup-script-for-windows\/","title":{"rendered":"Database Backup Script for windows"},"content":{"rendered":"

In one of the project I am working on, the application needs to be deployed on windows server. To take the database backup, I wrote the script which does the following :<\/p>\n

    \n
  1. Takes database dump and copy it to the backup folder.<\/li>\n
  2. Zip that backup file and rename it to the format “YYYYMMDD_HHMMSS”<\/li>\n
  3. Removes\u00a0 all the backups older than 30 days.<\/li>\n<\/ol>\n

    I used mysqldump<\/a> command to take database backup. To zip the backup file using the command line, I found 7-zip (download) which is freely available.\u00a0 We need to have forfiles.exe (download) which enables us to remove old backup files (say older than 30 days).<\/p>\n

    [bash]
    \n@echo off
    \nCLS
    \nset hour=%time:~0,2%
    \nif &amp;quot;%hour:~0,1%&amp;quot; == &amp;quot; &amp;quot; set hour=0%hour:~1,1%
    \nset min=%time:~3,2%
    \nif &amp;quot;%min:~0,1%&amp;quot; == &amp;quot; &amp;quot; set min=0%min:~1,1%
    \nset secs=%time:~6,2%
    \nif &amp;quot;%secs:~0,1%&amp;quot; == &amp;quot; &amp;quot; set secs=0%secs:~1,1%
    \nset year=%date:~-4%
    \nset month=%date:~3,2%
    \nif &amp;quot;%month:~0,1%&amp;quot; == &amp;quot; &amp;quot; set month=0%month:~1,1%
    \nset day=%date:~0,2%
    \nif &amp;quot;%day:~0,1%&amp;quot; == &amp;quot; &amp;quot; set day=0%day:~1,1%
    \nset datetimef=%year%%month%%day%_%hour%%min%%secs%
    \n&amp;quot;MYSQL_BIN_PATH\\mysqldump&amp;quot; –user=root –password=MY_PASSWORD MY_DATABASE_NAME &amp;gt; &amp;quot;BACKUP_FOLDER_PATH\\backup.sql&amp;quot;
    \n&amp;quot;7ZIP_EXE_PATH\\7z&amp;quot; a -tzip &amp;quot;BACKUP_FOLDER_PATH\\&amp;quot;%datetimef%&amp;quot;.zip&amp;quot; &amp;quot;BACKUP_FOLDER_PATH\\backup.sql&amp;quot;
    \ndel &amp;quot;BACKUP_FOLDER_PATH\\backup.sql&amp;quot;
    \n&amp;quot;FORFILES_EXE_PATH\\forfiles.exe&amp;quot; \/p BACKUP_FOLDER_PATH \/s \/m *.* \/d -30 \/c &amp;quot;cmd \/c del \/q @path
    \n[\/bash]<\/p>\n

    Prerequisites for the above script to work would be :-<\/p>\n

      \n
    1. Mysql and 7zip installed.<\/li>\n
    2. Forfiles.exe is downloaded<\/li>\n
    3. All the Path’s in script are replaced correctly.<\/li>\n<\/ol>\n

      I also used a background job to run this script automatically every hour on the working days. Though same can be achieved with windows scheduler too.<\/p>\n

      Hope this helped.<\/p>\n

      Cheers!
      \n~~Amit Jain~~
      \namit@intelligrape.com
      \nhttp:\/\/intelligrape.com\/<\/p>\n","protected":false},"excerpt":{"rendered":"

      In one of the project I am working on, the application needs to be deployed on windows server. To take the database backup, I wrote the script which does the following : Takes database dump and copy it to the backup folder. Zip that backup file and rename it to the format “YYYYMMDD_HHMMSS” Removes\u00a0 all […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":1},"categories":[1],"tags":[473,475,4843,474,472],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/2343"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=2343"}],"version-history":[{"count":0,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/2343\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=2343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=2343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=2343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}