Monday, January 24, 2022
Home Database

Database

Disable MySQL Strict Mode

This is enabled by default, but you can disable it in one of a couple ways.

Set-Up Master-Slave Replication for PostgreSQL 9.6 on Ubuntu 16.04

What we will do: Install PostgreSQL 9.6.Configure MASTER Server.Configure SLAVE Server.Copy PostgreSQL Data from MASTER to SLAVE.Testing.
- Advertisment -

Most Read

Safe Reboot Of Linux Using Magic SysRq Key

If you are working on kernel development, or device drivers, or running a code that could cause a kernel panic, the SysRq...

How to set a MySQL database to read-only mode

When we need to set the database as read-only on the fly (such as rebuild MySQL replication purpose) and we will use...

How to check LDAPS certificate and TLS version

Get OpenSSL (a list of 3rd party sites here; I went with this one). The connection to your DC thus: openssl...

How to run a manual backup on cPanel

You can use the /usr/local/cpanel/scripts/pkgacct script to create a cpmove archive for an account. After you create the archive, you can then restore the account on any cPanel...