To create table in PostgreSQL “CREATE TABLE” command is used : SYNTAX: CREATE TABLE table_name( column1 datatype, column2 datatype, …..…
Step 1: Remove any previous repository sudo rm -rf /etc/yum.repos.d/mongod* sudo yum clean all Step 2: create new repo file…
MongoDB Replication on same server with two secondary instances. Requirement : Primary Server (127.0.0.1) – Port : 27017 Secondary server…
pg_isready is utility to check whether postgres is running or not -bash-4.2$ ./pg_isready /tmp:5432 – accepting connections can write shell…
Start MongoDB without authentication 2. Create new role which we will use to login into database > use admin >…
Problem : We don’t want to give plain password in mysql_dump command so no one can see password while taking…
Selecting General Query and Slow Query Log Output Destinations Check log_output value (File/csv) mysql> show variables like ‘%log_output%’ ; +—————+——-+…
MySQL LOG TYPES Type Log Written to file Error log Problems due to starting, running, or stopping mysqld instances 2. General…
Download and add the repository wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update 2. Install MySQL sudo yum install mysql-server 3.…
Create Database SYNTAX Create database < database_name> Ex: mysql> Create database sqlnosql ; Query OK, 1 row affected (1.29 sec)…