Bash Script: Create MySQL Database & User with Optional Password

I have been using DigitalOcean for my personal projects. And one repeated things that I had to do is the creation of MySQL database & user. I know I could have used some CPanel like GUIs and even some of them came to my mind like VestaCP, Ajenti, ServerPilot, etc. But all come with sort …

Read moreBash Script: Create MySQL Database & User with Optional Password

Backup Magento project files / DB using the bash script

I have googled for the bash script to backup Magento sites/DB but none of them worked for me the way I wanted. So I decided to create a custom bash script which is simple and does the job perfectly. I have developed the script for my own need. But I thought it would be helpful …

Read moreBackup Magento project files / DB using the bash script

How to find the size/rows of Magento database & tables?

Introduction Magento is a giant e-commerce application having more than 300 tables. It uses an EAV model concept and provides different complex features which make the database huge. Sometimes you may wonder what’s the database size of your Magento database or individual tables so that you can work on some optimization task or freeing some …

Read moreHow to find the size/rows of Magento database & tables?