Databases
How to Migrate SQL Server Database to Amazon RDS Instanace
Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing…
Category: Databases
MySQL, MariaDB, PostgreSQL, MongoDB, Redis and SQL Server: install, manage, back up and tune.
Databases
How to Reset MariaDB root Password in Linux
Have you forgotten MariaDB root password? You don’t know how to recover it. Not to worry, this tutorial will help…
Databases
How to Backup SAP HANA Database using Command Line
SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is…
Databases
How to Setup LogAnalyzer with Rsyslog and MySQL
This article is second part of the article Setup Rsyslog with MySQL and LogAnalyzer on CentOS/RHEL systems. In the first…
Databases
20 Useful Tips for PostgreSQL Beginners
PostgreSQL is an advanced database management system used for storing structured or non-structured data. It supports both SQL (relational) and…
Databases
How to Install MySQL 5.7 on CentOS 7 & Fedora 36/35
MySQL community has released MySQL 5.7 Release. Its available on MySQL official website. For this article We are using CentOS…
Databases
Setup Database Mirroring in SQL Server 2012 with Certificates
Many times we faced issues with mirroring setup with authentication, So in this article we are going to configure database…
Databases
How to Reset ( Re-Sync ) MySQL Master-Slave Replication
Some times MySQL replication creates problems and slave could not sync properly from the master database server. It may cause…
Databases
How to Allow Remote MySQL Connections
Managing a MySQL database doesn’t always mean accessing it from the same server where it’s hosted. In many situations, especially…
Databases
How to Backup and Restore MySQL Stored Procedures & Triggers
The database is the most crucial part of any application, and as a developer, ensuring the safety of your database…