<tutorialjinni.com/>

The GPG keys listed for the MySQL 8.0 Community Server

Posted Under: MySQL on Oct 8, 2022
The GPG keys listed for the MySQL 8.0 Community Server
The official of GPG keys of MySQL are expired so the new installations and upgrades from the official package repository are failed with the following message.

Table is marked as crashed and should be repaired

Posted Under: MySQL on Sep 26, 2021
Table is marked as crashed and should be repaired
MySQL Table can crash for a variety of reasons, such as an abnormal shutdown or a power failure. This can also occur if the operating system run low on disk.

Remove duplicate rows in MySQL

Posted Under: MySQL on Mar 13, 2020
Remove duplicate rows in MySQL
This tutorial provide snippet on how to remove duplicate rows that may have created over time. This may be a result of a spam attack or by mistakenly repeating entries. They consume precious resources of the server and decrease over all performance of any system. There are many ways to remove duplicates rows form a MySQL server.

MySQL Import Database Dump Command Line

Posted Under: MySQL on Mar 10, 2020
MySQL Import Database Dump Command Line
There are multiple ways to import database dumps in MySQL/MariaDB. First way to import databases it to use mysqldump utility.

MySQL Select 1st Day of Month and Current Time

Posted Under: MySQL on Aug 29, 2018
MySQL Select 1st Day of Month and Current Time
MySQL snippet to select data between first day of the current month and current date.