Change Table Prefix for Magento 2 DB (After Installation)

During installation, Magento provides the option to configure the table prefix for your database. That’s great. What if you missed it or realized later that you needed to configure it when you already have real data (catalog, customer, sales, etc.) in your database? Don’t worry, we have got you covered. You just need to follow …

Read more

Import Product Reviews in Magento via SQL

Import Product Reviews/Ratings in Magento

Customers are more likely to make purchasing decisions when they see a product that has good reviews.Also, some search engines give sites with product reviews a higher ranking than those without. Since Magento doesn’t support default functionality for importing product reviews, we came up with a quick approach using SQL. Database Schema for Product Reviews …

Read more

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 more

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 that 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 more