Export - Automate

[joyce_ank]

I'm planning to automate the daily exports of our databases. How long does one need to keep these exports? To keep a couple of days exports will require that the file is put in a separate folder after each export in order not to overwrite it.

Thanks

[pando]

before export make a directory with date in order to track it

we keep 5 days export in Disk then tape many months

[Edited by pando on 05-13-2002 at 06:43 AM]

[joyce_ank]

What about a directory with days of the week so as not to keep changing the dates.

[pando]

well I mentioned that make a directory before improt, that is very easy in UNIX, set a variable and do

MYDATE=`date +"%Y%m%d"`
mkdir $EXPORT_PATH/$MYDATE

exp ...............................

[mrchrispy]

what about doing that on NT (I miss my old unix boxes)

[joyce_ank]

Well, I was just going to ask the same question because I use NT.

Thanks

[pando]

then sorry I am not a NT man.... however you can run shell scripts or obtain unix commands in NT with Cygwin, it´s freeware