First, write a batch processing file and give an example.
Copy codeThe Code is as follows:
Set rq = % date :~ 0, 10%
Exp system/system's password @ local service name file = d: \ backup \ bak % rq % full = yes log = d: \ backup \ bak % rq % buffer = 65536
C: \ Progra ~ 1 \ WinRAR \ rar.exe a-df d: \ backup \ bak % rq % d: \ backup \
Move/y d: \ backup \ *. rar d: \ databasebackup
The first one is to set the date string and use it later in the backup file name. file = d: \ backup \ bak % rq % is the backup file name of the exported database, full = yes, indicates that all data is exported. C: \ Progra ~ 1 \ WinRAR \ rar.exe a-df d: \ backup \ bak % rq % d: \ backup \ is the compressed file. The last one is to move the compressed file to d: \ databasebackupd: \ databasebackup directory.
You may be unfamiliar with parameters after exp. You can enter exp help = y at a command prompt to learn about these parameters.