Commands
Here you find a description of all database commands which you can enter in the console mode, in the Command text field in the GUI, or send to the BaseX server:
ADD
ADD (AS [name]) (TO [target]) [input]
Adds [input]
as [name]
to the database, using an optional
[target]
path.
ALTER
ALTER [USER|DATABASE] [...]
Alters user password or database name:
USER [name] ([password])
:
- alters the password of a user.
DATABASE [name] [newname]
- alters the name of a database.
BACKUP
BACKUP [name]
Creates a backup of the specified database.
CLOSE
CLOSE
Closes the currently opened database.
CREATE
CREATE [DATABASE|FS|INDEX|USER] [...]
Creates a new database, index or user:
DATABASE [name] ([input])
:
- creates the database
[name]
with an optional[input]
INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]
:
- creates the specified index
FS [name] [path] ([mountpoint] [backingstore])
:
- creates filesystem database
[name]
for[path]
- (using
[mountpoint]
and[backingstore]
if FUSE is activated)
USER [name] ([password])
:
- creates the specified user
CS
CS [query]
Evaluates the query and sets the result as new context set.
DELETE
DELETE [name]
Deletes documents from the currently opened database.
DROP
DROP [DATABASE|INDEX|USER] [...]
Drops a database, index or user:
DATABASE [name]
:
- drops the database
INDEX [PATH|TEXT|ATTRIBUTE|FULLTEXT]
:
- drops the specified index
USER [name]
:
- drops the specified user
BACKUP [name]
:
- drops the database backup
EXIT
EXIT
Exits BaseX.
EXPORT
EXPORT [path]
Exports the database to [path]
.
FIND
FIND [query]
The following modifiers can be used:
- = : looks for exact text nodes"
- @= : looks for exact attributes
- @ : looks for attributes
GRANT
GRANT [NONE|READ|WRITE|CREATE|ADMIN] (ON [db]) TO [user]
Grants permissions (on a database) to a user.
HELP
HELP ([command])
If [command]
is specified, information on the specific
command is printed; otherwise, all commands are listed.
INFO
INFO ([DATABASE|INDEX|STORAGE])
Shows information on the currently opened database:
no argument
: show global information
DATABASE
: shows database information
INDEX
: shows index information
STORAGE [start end] | [query]
: show internal database table
KILL
KILL [name]
Kills all sessions of the specified user.
LIST
LIST
Lists all available databases.
OPEN
OPEN [name]
Opens the specified database [name]
.
OPTIMIZE
OPTIMIZE
Optimizes the current database structures.
PASSWORD
PASSWORD ([password])
Changes the user's password.
RESTORE
RESTORE [name]
Restores a backup of the specified database.
RUN
RUN [path]
Evaluates an query from [path]
and prints the result.
SET
SET [option] ([value])
Available options [option]
with value [value]
= on/off:
QUERYINFO
: Display of query info
DEBUG
: Display of debug info
SERIALIZE
: Serialization of query results
CHOP
: Chopping of XML whitespaces
ENTITY
: Parsing of XML entities
TEXTINDEX
: Text indexing
ATTRINDEX
: Attribute value indexing
FTINDEX
: Full-text indexing
PATHINDEX
: Path indexing
SHOW
SHOW [DATABASES|SESSIONS|USERS|BACKUPS]
Shows server information:
DATABASES
: shows currently opened databases.
SESSIONS
: shows current database sessions.
USERS (ON [db])
: shows users (on a database).
BACKUPS
: shows backups.
XQUERY
XQUERY [query]
Evaluates the specified query and prints the result.