Create extension attribute to product entity in magento 2
To create extension attribute to product entity, I have followed the simple steps to make understandable for new magento 2 developer. I selected 'brand' attribute name for the product entity.…
Extract gz sql file and import in database using cli
To import sql compressed gz database file in the database server using cli. Follow the instructions and import the database file. Syntax: zcat ~/ | mysql -h hostname -u user-name…
Generate a translation dictionary for a custom module or theme in Magento 2
As per other open-source solutions, Magento enables multiple language support. You can generate and integrate multiple languages with Magento native and 3rd parties translation dictionaries. If you want to translate…
Magento 2 Installation Using Composer in 3 easy steps
If you want to insall Magento 2 version using composer then follow these three simple steps. You must install the composer first then follow these simple steps to install Magento,…
Copy File From One Server To Another In Linux Via Secure Copy (SCP)
What is Secure Copy (SCP)? SCP allows to transfer copy of a file from one server to another server in linux. It uses SSH for data transfer and authentication. Copy…
Magento 2 Create Admin User Using Command Line
If you want to create magento 2 administrator via command line, then first access the command line via SSH and navigate to magento 2 installed directory's root and run the…
Import, export and drop database using command line
Import, export and drop database using command line Import Database using command line: To import database in your mysql host mysql account using command line (cli). Follow this syntax Syntax:…
MySQL Query To Find The Tables Using Most Space in Database
MySQL Query To Find The Tables Using Most Space in Database Problem: How to get the table list which is using most space in MySQL/MariaDB database? Solution: If you want…
Magento 2 Install sample data using composer or deploy sample data
Magento 2 Install sample data using composer or deploy sample data. Magento 2 install using composer: Step 01: First to add dependencies in the file. Composer Dependencies Cli: composer require…
Remove product items from mini-cart in Magento 2
Remove product items from mini-cart if shopping cart empty. Problem 01: In Magento 2, if you remove shopping cart items (from quote table) manually then you will notice that the…