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,…
Bash
In this category, we will share some tips using Bash [shell] script.
Index:
- How to check the execution time of your script in cron?
- Managing MySQL database backup
- How to change the database user password – cPanel?
Dump Mongo DB and move it to an S3 bucket.
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…
Managing MySQL database backup
How to create/restore MySQL databases’ dump/backup of all the databases? Yes!! this is an important section in MySQL administration, and every Linux SysAdmins should know about it. Because, creating backups are such an important task for a SysAdmin. In MySQL, the…
How to check the execution time of your script in cron?
Do you have a long running script on your server’s cron list? And you really wanna get notified about the total execution time for your cron? Yeah, here we go! We can not find out the total execution time from…
How to change the database user password – cPanel?
Changing the database user password using bash script? Change the database user password, need simple solution!! The MySQL community has depreciated “old_passwords” option since MySQL 5.6 version. So we won’t be able to recollect the password from an old password…