Usage and Access via 7 Modes

You can access the database in 7 different ways. Try out VanadiumDB Crystal (Internal UI) or MariaDB / MySQL compatible interface if you are a beginner:

VanadiumDB Crystal - User Interface / GUI

VanadiumDB Crystal is teh Angular User interface written for the VanadiumDB. It uses the API REST access.

Install is possible via Docker.

You can access the software via your favorite browser at http://localhost:60057

You cannot log in with the root user via the API or the user interface Crystal. Use the CLI mode. Register a new user in Crystal or create a user via the root user in the CLI.

HediSQL - External User Interface

Get HediSQL for your system and install the software.
Start the software
Create a new connection

Choose Network type: MariaDB or MySQL (TCP /IP)
Hostname 127.0.0.1
User: root
Password: test
Port: 3306
Comment: VanadiumDB

Click on the button Open

On the right side you can select your databases. Go to tab query and run your commands.

Other user interface like PHPMyAdmin are not working or not tested.

MariaDB / MySQL Compatible Interface

You can find more information how to access VanadiumDB with your favorite programming language at Connectors

CLI / Prompt - Simple input for SQL-querys in the terminal

On Linux: To start the binary:

./vanadiumdb cli

Now you see

20XX/XX/XX 07:41:03 Started in CLI-Mode
Input SQL command:

You can directly prompt the database default with some art masterpieces.

Type your command USE default; SELECT * FROM art; in and get the result.

Import Mode - Import SQL scripts from other databases

On Linux: To import SQL-scripts run this command:

./vanadiumdb import /full/path/to/sqlimport.sql

Windows PowerShell:

.\vanadiumdb.exe import sqlimport.sql

Import errors are listed in the list by the command of the SQL script. Import scripts with one command per line are better suited to find issues quicker.

Dump Mode - Export database for other database / backup

Dump all databases with

./vanadiumdb dump

Dump selected databases with

./vanadiumdb dump mydatabasename

Dump a single table with

./vanadiumdb dump mydatabsename mytablename

A SQL file is created from the process in the folder you are working with.

Restore Mode - Travel in time

You can travel back in time if you set up the settings correctly.

VanadiumDB backups itself a 1 am completely and save a dump in the backup folder of your home directory.

When you start the restore, the all databases and data are lost beside the user table. Backup the current data before starting a restore.

./vanadiumdb dump

Shut down current operation of the database
Start the restore menu by typing

./vanadiumdb restore

Select the point of time for the restore
Wait for the restore to finish
Start the database again
Alter access or users if needed

Logging Mode - Get every action done on Your Data

Print out logs in console:

./vanadiumdb logs

Export logs in the same directory as the executable:

./vanadiumdb logs export

VGwort

Last updated: