Topics tagged mysql

Topic	Replies	Views	Activity
How did I solve «Failed to add the foreign key constraint 'SEARCH_QUERY_STORE_ID_STORE_STORE_ID' to system tables» on `bin/magento setup:upgrade`? Upgrade sql , database , setup:upgrade , foreign-key , mysql , upgrade	1	92	May 7, 2026
How to avoid dumping data from big tables (like `report_viewed_product_index`) using MariaDB? How To sql , database , mysql , mariadb	2	89	May 3, 2026
How to reduce the database size after long-term use of a website? Administration sql , database , mysql	2	2294	May 3, 2026
How did I fix «Module 'Yotpo_Yotpo'» / «sales_order_data_exporter indexer does not exist» on `bin/magento setup:upgrade` while upgrading Magento from 2.4.5-p10 to 2.4.8-p3? Upgrade mysql , upgrade , magento24 , magento248 , yotpo	2	39	January 24, 2026
How did I suppress the «Current version of RDBMS is not supported» error? How To database , setup:upgrade , mysql , upgrade , compatibility	1	58	August 25, 2024
The recent Cloudways update broke `bin/magento setup:upgrade` for Magento < 2.4.4, 2.4.4 < 2.4.4-p9, 2.4.5 < 2.4.5-p8 Issues mysql , mariadb , hosting , cloudways	1	88	August 25, 2024
How did I fix «Current version of RDBMS is not supported. Used Version: 10.5.25-MariaDB-deb11-log. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.4)» on `bin/magento setup:upgrade`? Issues database , setup:upgrade , mysql , mariadb , upgrade , hosting , cloudways , compatibility	1	262	August 25, 2024
How did I fix «mysqldump: Got error: 145: Table 'catalogsearch_fulltext' is marked as crashed and should be repaired when using LOCK TABLES» in OpenMage 19.5.2? Magento 1 database , mysql , full-text-search , indexing , search , openmage , openmage-19	1	23	August 18, 2024
How did I fix «Item (Mage_Catalog_Model_Product) with the same id "…" already exist» on loading `Mage_Catalog_Model_Resource_Product_Compare_Item_Collection` in Magento 1? Magento 1 sql , product-comparison , bug , mysql , bug-fix , magento1	1	261	March 18, 2024
Deadlock occur during mass product import programatically Ask your questions database , mysql , magento22	7	4688	September 15, 2020
How to restart MySQL in Magento Cloud? Administration mysql , enterprise-edition , magento-cloud	0	2521	June 28, 2019
How to install MySQL 5.7 for Magento 2 to Ubuntu 18? Installation mysql , ubuntu	1	715	May 7, 2019
How to install MySQL 5.7 for Magento 2 to Debian 8 (Jessie)? Installation mysql , debian	4	4840	May 7, 2019
How to install MySQL 5.7 for Magento 2 to Debian 9 / 10? Installation mysql , debian	1	2227	February 21, 2018
How to install MySQL 5.6 for Magento 2 to Debian 8 (Jessie)? Installation mysql , debian	1	2863	February 13, 2016
How to dump a store's settings for convenient reading and comparison in tools like Araxis Merge? Administration database , mysql , debug , command-line	1	805	November 10, 2018
How to dump a store's database schema for convenient reading and comparison in tools like Araxis Merge? Database mysql	1	892	November 10, 2018
How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire? Issues database , mysql	1	5562	July 30, 2018
How to disable the standard Magento 2 authentication timeouts from the command line? Administration security , timeout , authentication , mysql , cookie , command-line	0	1620	March 3, 2018
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? Administration database , mysql	1	9897	August 14, 2017
How to get the MySQL server's version with PHP? Database mysql , version	0	869	December 23, 2016
While installing all files, the installation wizard uses the default mysql port 3306 but I did provide port 2418 at the SQL step, e.g. 127.0.0.1:2418 Issues mysql , installation	0	824	October 30, 2016
How many rows can a Magento 2 database table contain? Administration database , mysql , limitation , db-table , innodb	0	1910	May 30, 2016
Where is MySQL's error log? Administration log , mysql , diagnostics	1	1647	April 8, 2016
How to get an ID of the last database record inserted Database database , mysql	0	11178	January 13, 2016
Propose to move the \Magento\ImportExport\Model\ResourceModel\Helper::getNextAutoincrement() method to the \Magento\Framework\DB\Adapter\Pdo\Mysql class and to the \Magento\Framework\DB\Adapter\AdapterInterface Issues sql , database , db-table-increment , mysql , improvement , code-quality	1	1253	January 11, 2016
«WARNING: pdo_mysql not enabled; libraries and headers not found» PHP 7 on Windows php7 , mysql , windows	0	1107	December 19, 2015