CREATEBACKUP targetdirectory

The syntax above creates a full backup of the table structure and theirs content of the database, except the uploaded files. The whole backup will be in compressed ZIP format.

  • targetdirectory: The full path of an existing directory to create backup to. If you have no existing directory you can point to the database's archive directory using “archive” keyword as target directory parameter.

Practical example

Command:

CREATEBACKUP c:\backup

Output:

CREATEBACKUP :: C:\BACKUP



Practical example (using archive)

Command:

CREATEBACKUP archive

Output:

CREATEBACKUP :: ARCHIVE