The Shopware 6 Importer/Exporter comes with pre-made default profiles. Unfortunately, these default profiles do not include all possible fields and columns. Because adding each mapping and column one by one in the backend is pretty slow, it’s easier to just run the following two queries. After that, you will have full profiles including all available […]
By Erik. Erik Pöhler's Weblog.This is a tiny bash script, supposed to be executed via cronjob, which helps you back up your MySQL database on a regular basis.
By Erik. Erik Pöhler's Weblog.This article shows you how to export a Shopware 6.4 MySQL 8.x database to a file and then reimport the dump back into MySQL 8.x without any problems.
By Erik. Erik Pöhler's Weblog.The current version of Shopware 6.4 officially supports MySQL and MariaDB. That said, it’s not compatible with a lot of minor and bugfix releases from the last one and a half years. Although the underlying doctrine/dbal package has been updated to work with current MySQL >= 8.0.20 in July 2020 it hasn’t made its way […]
By Erik. Erik Pöhler's Weblog.This is part 9 of my article series 25+ Tutorials on How to boost the performance of your WooCommerce store. This article focuses on Wordpress's poor table indexes and how to improve them. In particular all the meta tables, which are used heavily throughout a Wordpress site.
By Erik. Erik Pöhler's Weblog.
