Archive for the ‘Command Scripts’ Category.

Backup Oracle database with Windows Batch Script

This simple batch script creates a new folder based on the date and time and then executes a oracle database dump.

REM Backup oracle database

@echo Starting database backup

REM get the current datestamp in the format year-month-day-hour-minute
SET DATESTAMP=%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%-%time:~3,2%

REM Create a new directory
md "c:\backup\%DATESTAMP%"

REM backup database
REM Dont forget to change username and password
exp username/password@xe FILE="c:\backup\%DATESTAMP%\databasename.dmp"

@echo Finished backing up database to c:\backup\%DATESTAMP%

Create m3u playlist from directory list

This little command script iterates all sub folders to create an m3u playlist containing mp3 files. The m3u playlist can then be played using winamp.

To create the command script, open a text editor and add the following line.

dir *.mp3 /b /s > "playlist.m3u"

Next save the file as create-playlist.cmd. To execute place the command script in the same folder as the mp3s and double click create-playlist.cmd, this will generate playlist.m3u. Then open playlist.m3u in winamp.