Requirement: Need to create a script to create Mongo DB dump and move the dump to an AWS s3 bucket. Prerequisites: SSH access to Mongo DB server, IAM user with AWS s3 full [or write] access, aws-cli on server, knowledge…
Database
Dump Mongo DB collections and move it to an S3 bucket.
Requirement: Need to write a script to create Mongo DB collections dump and move the dump to an AWS s3 bucket. Prerequisites: SSH access to Mongo DB server, IAM user with AWS s3 full [or write] access, aws-cli on server,…
How to know the MySQL uptime from commandline – 3 Methods
MySQL uptime. In some situations, we need to check the uptime for MySQL in your server. We can not afford the downtime of a database engine. As a system engineer you must know the linux command-line options to find the…
How to enable remote MySQL for an IP address on a cPanel server via CSF
Enable remote mysql In CSF, there is an option to allow IP address in a file which is ‘csf.allow’ that allows connections from external. Please do follow the steps here for enabling remote MySQL for an IP address on a…
[Solved] : MySQL server has gone away – error while restoring the DB
Managing MySQL server is one of the interesting thing for every sys admins. In this article I’m just sharing a quick fix for the error that I got while restoring the database from its backup file. I hope this will…
Unable to establish a PHP session – PHPMyAdmin error
PHPMyAdmin error Do you ever come across the following error when you access PHPMyAdmin from cPanel? Access Denied Unable to establish a PHP session. If you believe that this is in error or inadvertent, contact your system administrator and ask…
How to change default time zone in MySQL?
Is it possible to change the time zone in MySQL? Yes we can change the default time zone in MySQL via command-line. We can’t change the time zone for a single DB, it’s a global change. To change this feature, you must…