Mastodawn

The wp_usermeta table is a good example of how not to use a tabular #database like #MySQL. Please do not design your #databases this way.

If you or an add-on to your software needs to add more data fields, the correct way to do so is to either ALTER TABLE ADD COLUMN or (for add-ons that don't wish to disturb the core application's tables) to CREATE a related TABLE (perhaps in a separate schema, if using a database like #PostgreSQL that supports such a notion).

#WordPress #programming

PrecisionSQL 18h ago

How to Avoid Leading Wildcards That Kill Indexes

LIKE '%text' forces a full table scan.

#mysql #like #index #performance #howto #search

https://www.youtube.com/watch?v=HYdQSccv-AI

How to Avoid Leading Wildcards That Kill Indexes #howto

YouTube

FreePixel 1d ago

#android #server #php #mysql #mariadb #apache #phpmyadmin #ftp
Découvrez "AWebServer: Apache, PHP, SQL, SSH"
https://play.google.com/store/apps/details?id=com.sylkat.apache

Hans-Cees 🌳🌳🤢🦋🐈🐈🍋🍋🐝🐜1d ago

totday I will be testing what happens if you tel #SqlAlhemy to add a record to #MySql that already exists. Or adds that same record with one extra keyValue pair.
#linux
It doesnt say in the docs, or I couldnt find it
#sql

ck 👨‍💻1d ago

In recent years, both MySQL and MariaDB have changed their replication wordings. Slave has become Replica.

But to make the situation more complex: #MariaDB only changed the replication commands but kept the output field names while #MySQL changed the wording in the output, too.

The newest version of the check_mysql_slavestatus #opensource #monitoring plugin now supports all these cases and auto-detects which commands to use and which fields to parse.

https://www.claudiokuenzler.com/blog/1526/check-mysql-slavestatus-monitoring-supports-replica-and-slave-replications

check_mysql_slavestatus monitoring plugin now supports both REPLICA and SLAVE replications

The latest release of check_mysql_slavestatus supports both MySQL and MariaDB replications and is backward compatible.

Claudio Kuenzler

Geek Rewind Mar 21, 2025

Migrate MySQL to MariaDB on Ubuntu 24.04

The article outlines the process of migrating from MySQL to MariaDB on Ubuntu 24.04. It emphasizes the importance of backing up databases, checking compatibility, uninstalling MySQL, installing MariaDB, and restoring backups. Following these steps ensures a smooth transition, allowing users to benefit from MariaDB’s additional features and optimizations.

https://geekrewind.com/migrate-mysql-to-mariadb-on-ubuntu-24-04/

fortrabbit 2d ago

Specs for the pros. Meet our new detailed pricing table. #php #mysql #hosting
www.fortrabbit.com/pricing/details

Geek Rewind Feb 21, 2025

Secure MySQL with Self-Signed SSL Certificate on Ubuntu 24.04

This article discusses the implementation of MySQL self-signed SSL certificates on Ubuntu 24.04 to enhance database security. It covers generating certificates, configuring SSL connections, and enforcing SSL usage for users. Key points include improved encryption, automatic SSL configuration, user restrictions, and validation of SSL setups for a secure database environment.

https://geekrewind.com/secure-mysql-with-self-signed-ssl-on-ubuntu-24-04/

Geek Rewind Feb 24, 2025

Backup and Restore MySQL database with mysqldump

This article outlines the process of backing up and restoring MySQL databases using the mysqldump tool on Ubuntu 24.04. It details commands for backing up all databases or specific ones, advises on using table locking or transactions for data integrity, and emphasizes regular backups, effective monitoring, and testing restore processes to prevent data loss.

https://geekrewind.com/backup-and-restore-mysql-database-with-mysqldump/