Databases
How to Set Up MySQL Master-Master Replication
MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server.…
Category: Databases
MySQL, MariaDB, PostgreSQL, MongoDB, Redis and SQL Server: install, manage, back up and tune.
Databases
Shell Script to Backup MySQL Database
In this tutorial, you will find a simple bash script for backing up a MySQL database. The script takes a…
Databases
How to Set Up MySQL Master-Slave Replication
MySQL replication is a process where a master server replicates its data to one or more slave servers. This can…
Databases
Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted
Error: Below issue generally comes with database incompatibilities with the current version of MySQL. It may happen due to MySQL…
Databases
SQLite3 SQL Command Uses with Examples
SQLite is a lightweight SQL database that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. Except some of the…
Databases
Setting Up Nginx + MariaDB + PHP-FPM on CentOS/RHEL 9/8
Introduction The LEMP stack, consisting of Linux, Nginx, MariaDB, and PHP-FPM, is a powerful combination for hosting dynamic websites and…
Databases
MySQL Database Backup RPM
I had created this rpm few months back. Now it is available for all users. This rpm have a simple…
Databases
How To Create a New User and Grant Permissions in MySQL
MySQL is a relational database management system, used for storing data in form of tables and records. You can insert,…
Databases
How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE
Sometimes SQL Server logs files acquire a large space on the disk. In that case, we need to reduce the…
Databases
MySQL Database Backup to FTP Server – Shell Script
As a system administrator, you need to take backup on daily basis. Backups are very useful to recover data from…