Changes

Jump to: navigation, search

Scheduling Backup

823 bytes added, 17:03, 2 August 2016
no edit summary
{{Under construction| }}
Modify the following script:<lipre>@echo off@echo Backing up database. This may take awhile, do not close this window.:: C:\xyz being the location you desire. You must have read/write access to it. It has to be replaced at FOUR positions in this script.c:\imsmang\pgsql\bin\pg_dump -U imsma > C:\xyz\dump.sql@echo Creating folder:: Creates a folder with the date as a timestamp, similar to the backups done in IMSMA. Then moves the dump.sql to it.set foldername=Backup_%date:~10,4%_%date:~4,2%_%date:~7,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%mkdir c:\xyz\%foldername%move c:\xyz\dump.sql c:\AnneLifiler\%foldername%\cmd /c echo F | xcopy C:\IMSMAng\server\attachments c:\xyz\%foldername%\server\attachments /c /e /i /h /q@echo Done.</pre> Save it with name runIMSMAbackup.bat. Do NOT save it in the ''C:\IMSMAng'' folder.Schedule a task in the Operating System's Task scheduler. The following steps are done with Windows 7, follow those steps:
<ol>
<li>Go to Control Panel &rarr; Administrative Tools &rarr; Task Scheduler</li>
<li>Browser to the previously created script, e.g. C:\runIMSMAbackup.bat Click '''Next''' and then '''Finish'''.</li>
</ol>
</li>
The {{IMSMANG}} backup should now start at the specified time. <br/>
6,632
edits

Navigation menu