Category: orientdb

OrientDB – Freeze Database ”; Previous Next Whenever you want to make the database state as static it means a state where the database didn’t respond to any of the read and write operations. Simply said, the database is in freeze state. In this chapter, you can learn how to freeze the database from the OrientDB command line. The following statement is the basic syntax of the freeze database command. FREEZE DATABASE Note − You can use this command only after connecting to a particular database either in remote or local database. Example In this example, we will use the same database named ‘demo’ that we created in the previous chapter. We will freeze this database from CLI. You can use the following command to freeze the database. Orientdb {db = demo}> FREEZE DATABASE If it is successfully executed, you will get the following output. Database ”demo” was frozen successfully Print Page Previous Next Advertisements ”;

OrientDB – Disconnect Database ”; Previous Next This chapter explains how to disconnect to a particular database from the OrientDB command line. It closes the currently open database. The following statement is the basic syntax of the Disconnect command. DISCONNECT Note − You can use this command only after connecting to a particular database and it will only close the currently running database. Example In this example, we will use the same database named ‘demo’ that we created in the previous chapter. We will disconnect from demo database. You can use the following command to disconnect the database. orientdb {db = demo}> DISCONNECT If it is successfully disconnected, you will get the following output − Disconnecting to database [plocal:/opt/orientdb/databases/demo] with user ”admin”…OK orientdb> Print Page Previous Next Advertisements ”;

OrientDB – List Database ”; Previous Next This chapter explains how to get the list of all databases in an instance from the OrientDB command line. The following statement is the basic syntax of the info command. LIST DATABASES Note − You can use this command only after connecting to a local or remote server. Example Before retrieving the list of databases, we have to connect to the localhost server through the remote server. It is required to remind that the username and password for connecting to the localhost instance is guest and guest respectively, which is configured in the orintdb/config/orientdb-server-config.xml file. You can use the following command to connect to the localhost database server instance. orientdb> connect remote:localhost guest It will ask the password. As per the config file password for guest is also guest. If it is successfully connected, you will get the following output. Connecting to remote Server instance [remote:localhost] with user ”guest”…OK orientdb {server = remote:localhost/}> After connecting to the localhost database server you can use the following command to list the databases. orientdb {server = remote:localhost/}> list databases If it is successfully executed, you will get the following output − Found 6 databases: * demo (plocal) * s2 (plocal) * s1 (plocal) * GratefulDeadConcerts (plocal) * s3 (plocal) * sample (plocal) orientdb {server = remote:localhost/}> Print Page Previous Next Advertisements ”;

OrientDB – Restore Database ”; Previous Next As like RDBMS, OrientDB also supports restoring operation. Only from the console mode, you can execute this operation successfully. The following statement is the basic syntax for restoring operation. orientdb> RESTORE DATABSE <url of the backup zip file> Example You have to perform this operation only from the console mode. Therefore, first you have to start the OrientDB console using the following OrientDB command. $ orientdb Then, connect to the respective database to restore the backup. You can use the following command to connect to the database named demo. orientdb> CONNECT PLOCAL:/opt/orientdb/databases/demo admin admin After successful connection, you can use the following command to restore the backup from ‘backup-demo.zip’ file. Before executing, make sure the backup-demo.zip file is placed in the current directory. Orientdb {db = demo}> RESTORE DATABASE backup-demo.zip If this command is executed successfully, you will get some success notifications along with the following message. Database restored in 0.26 seconds Print Page Previous Next Advertisements ”;