# 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.

> ## XML import and export in SQL

>         select export_xml(<file-path>)

>         select import_xml(<file-path>)