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

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

Install & Configure Varnish Cache for Magento 2

The performance of a website is always the key factor for the higher conversion rate. Fortunately, Magento 2 (both CE & EE) comes by default with the support for FPC (Full Page Caching), Varnish & Redis to make your store fly. In this tutorial we will be discussing brief info about Varnish, it’s installation and …

Read moreInstall & Configure Varnish Cache for Magento 2