Author: Abhishek Yadav
-
Enable Data Load Local InFile
We were getting below error at the time of loading data into MySQL. Error: Programming Error: 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides. Solution: Check the status of local_infile variable in MySQL… > show variables like ‘%local%’; +—————+——-+ | Variable_name | Value | +—————+——-+ |…
//
-
Import CSV File Into PostgreSQL
Create a Table in Postgres CREATE TABLE persons ( id SERIAL, first_name VARCHAR(50), last_name VARCHAR(50), dob DATE, email VARCHAR(255), PRIMARY KEY (id) ); Create or Import csv file I am creating here… vi emp.csv First Name,Last Name, DOB,Email Abhishek, Yadav,18-Dec-1982,[email protected] Deepak, Varma,20-Jan-1982,[email protected] Connect PostgreSQL and execute below command to import the csv file into persons…
//
-
Database restore on destination and fix orphan user
In the article, we are going to demo a backup and restore process from source DB server to destination DB Server. In the demo we are performing below high-level tasks… 1. Create a login and grant access to a DB on our source server. 2. Take a DB backup on the source server. 3. Restore…
//
-
Read a big file using PowerShell
Get-Content C:\MySQL_Dump_8April2022\agii-tdsqlpw01_08April_11PM.sql | Select-Object -skip 0 -first 100
//
-
Step by Step implementing Log Shipping
Log Shipping enables you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. ADVANTAGES OF LOG SHIPPING- DISADVANTAGES OF LOG SHIPPING- TYPES OF LOG SHIPPING –…
//
-
Methods to change windows authentication to mixed mode (windows and SQL server authentication)
Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication Ø Enable Mixed mode authentication using Management studio Ø Enable Mixed mode authentication using Registry editor 1. Enable Mixed mode Authentication using MANAGEMENT STUDIO- STEP-1: Open a server in Management studio. Go to server -> right click -> instance ->properties…
//
-
MySQL master – slave replication setup
Hi guys, I hope you are doing great. Today here I am going to explain about MySQL master – slave replication setup. For the setup I have two servers clota-labl01 and clota-labl02. Here on clota-labl01 I am going to setup master and clota-labl02 as slave DB. Connect master server… ++++++++++++++++++++ clota-labl01 ++++++++++++++++++++ my.cnf configuration… =================…
//
-
ACID Properties of RDBMS
Hii guys, I hope you are doing great, Today here I am going to explain you about the ACID properties of RDBMS and its types. Transaction- Any operation that reads from or writes to a database is referred to as a transaction in relational databases. A transaction is a logical unit of work that can…
//
-
PostgreSQL Basic Commands
Basic Command Description psql -d database -U user -W Connects to a database under a specific user psql -h host -d database -U user -W Connect to a database that resides on another host psql -U user -h host “dbname=db sslmode=require” Use SSL mode for the connection \c dbname Switch connection to a new database…
//
-
Tablespace in PostgreSQL
Tablespace In PostgreSQL, tablespaces enable administrators to specify places in the file system where files representing database objects can be kept. When generating database objects, a tablespace can be referred to by name once it has been created. By using tablespaces, an administrator can control the disk layout of a PostgreSQL installation. This is useful in at…
//
-
Enabled DAC to connect remotely
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…
//
-
Steps to configure Hide DB Instance
Hey guys, In this blog I am going to explain you about “Hide DB Instance” STEP -1: To begin, start SSMS and connect to the server. STEP -2: Expand Database Engine in Network Servers and look for any servers connected to Database Engine, as shown below. Now, if…
//