Bash Script: Easily Backup your Magento2 Code Files + Database

We had created a similar Backup Script for Magento1 in the past. Now we are back with the much-improvised version for Magento2. You must be wondering why we needed a bash script for Magento2 backup even it comes up with inbuilt console command: php /path/to/magento2/bin/magento setup:backup -v –code –media –db Some of the reasons are: …

Read moreBash Script: Easily Backup your Magento2 Code Files + Database

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

Sandbox script for quick testing in Magento2

What’s your approach for quick & dirty testing in Magento2? Creating a test module with a controller and executing it from browser to see the output? Creating a Console module and executing via CLI? Obviously, above two approaches takes time. Rather I would create a simple script (a single file) and put it somewhere in …

Read moreSandbox script for quick testing in Magento2

MySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

When you export the Magento database dump from MySQL 5.5.x and try to import in MySQL 5.7.x, You are likely to face an error: ERROR 1031 (HY000) at line 3002: Table storage engine for ‘catalog_product_relation’ doesn’t have this option PROBLEM This is probably due to the table option that you have in your CREATE TABLE …

Read moreMySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

Install Bash Completion for Mac OS-X

One of the nicest features of the modern shell is built in “completion” support. This allows you to complete commands and their arguments easily without memorizing. Unfortunately, Mac OS-X bash shell doesn’t have completion feature by default unlike Ubuntu(Debian based Linux OS). But the good thing is you can easily install the auto-completion by using …

Read moreInstall Bash Completion for Mac OS-X