SQL Data Import and Export operations

xSQL provides a number of backup options in the form of specific commands to backup the database or save a snapshot as well as to save the database metadata and dictionary. These operations can also be executed via the following function calls in SQL select statements:

 
    select backup( <dbsFile-path>, <logFile-path>, nTreads );
     
    select save_snapshot( <imageFile-path> );
     
    select save_metadata( <configFile-path> );
     
    select save_class( <file-path>, <table-name> );
     
    select load_class( <file-path>, <table-name> );
     
    select save_dictionary( <schemaFile-path> );
     

Note also that if one of these select statements is executed by a remote client, all of the file names refer to the server's file system.