Tutes Club

Tag: MySQL

  • How to speed up slow Magento indexer process? Maria DB 10.4

    Category Products index taking too much time? bin/magento index:reset bin/magento index:reindex Stuck at category products index … Here is the solution if you are using MariaDB 10.4 You need to update options/parameters for your db. If using RDS, edit “DB instance parameter group” that you are using and update these 2 values: After these changes,…

  • How to export multiple selected tables in PMA phpmyadmin (but not all tables)

    Click on export, and choose “custom” export method. Lets say you want to export first 20 tables only. Open chrome or browser console [ctrl+shift+j], enter the following: For next 20, use 20,50 as arguments in slice function used above.

  • How to solve MySQL server gone away error Maria Db update on cPanel and WHM?

    This is related to new MariaDb upgrade from 10.1.41 to 10.1.42 and also for servers which were updated from 10.2.27 to 10.2.28 Go to solution ( Special Thanks to @Valetia ) You will see errors in following formats/messages: No file or input found MySQL Server has gone away Connection to MySQL Server failed sqlstate[hy000]: general…

  • How to change attribute dropdown type to multi-select in Magento 2?

    Short Answer: Not possible via Magento2 Admin Backend. Solution: You need to update eav_attribute table and edit information about backend_source, frontend_input etc. Simple query for that is: Replace YOUR_ATTRIBUTE_ID_INTEGER with your attribute_id like 355 Reference: https://stackoverflow.com/a/57701845/2229148

  • How to wipe all the tables and data in MySQL? Clean whole database

    Will not work via phpmyadmin or any script. this has to be run in cmd/terminal Quick Command Source: https://gist.github.com/harshvardhanmalpani/e670a8de7aa81673364dd48f125cb9ac

  • How to reverse the ids in a mysql table column without breaking primary key constraint?

    Let me explain the problem scenario: Let us assume we have a table with 4 columns in it out of which 1 is PRIMARY column and rest 3 contain some data. What we want to do is to reverse the primary key IDs for that data keeping the rest of data intact. It is like…

  • Some of the most important SQL commands.

    SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and it helps maintain the integrity of databases, regardless of size. Most of the actions you need to perform on a database are done with SQL statements. SQL commands are…

  • Creating a table in PhpMyAdmin Xampp server.

    Hello People. In this post we will discuss that how you can create a table in phpmyadmin xampp server for your php project. Before creating a table first you must create a database, because without database you can not create a table. steps to create a table in phpmyadmin. Start your Xampp server and open…

  • Connection timeout with MySQL database.

    MySQL disconnects automatically after some time. If you experience MySQL timeouts, it could be due to heavy or very long MySQL queries. You can try using mysql_reconnect command before every query, and it should be fine. MySQL server timeout can occur for many reasons but most commonly it is caused by either an application bug, a network timeout issue, or…

  • How to repair a MySQL database?

    How to repair a MySQL database?

    Hello! Good to see you. This is going to be a very important article because we are about to discuss  “How to repair a MySQL database?” Why repair MySQL Database? Databases can become corrupted for any number of reasons, from software defects to hardware issues. If this occurs, you can try to repair the database.…