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

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

Configure your Bash Shell for Magento 2 CLI Commands

One of the major improvement in Magento 2 is the introduction of CLI commands based on Symfony Console Component. CLI commands can perform multiple tasks. Some of them are: Installing Magento (and related tasks such as creating or updating the database schema, creating the deployment configuration, and so on) Clearing the cache Managing indexes, including …

Read moreConfigure your Bash Shell for Magento 2 CLI Commands

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