{"id":2343,"date":"2010-12-14T00:36:17","date_gmt":"2010-12-13T19:06:17","guid":{"rendered":"https:\/\/2thenew.online\/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:\/\/2thenew.online\/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":4,"footnotes":""},"categories":[1],"tags":[473,475,4843,474,472],"class_list":["post-2343","post","type-post","status-publish","format-standard","hentry","category-technology","tag-backup","tag-bash","tag-database","tag-script","tag-windows"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t