Créer un compteSe connecter

Recherches récentes

Aucune recherche récente

Options de recherche

Disponible uniquement lorsque vous êtes connecté.
mastouille.fr est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Mastouille est une instance Mastodon durable, ouverte, et hébergée en France.

Administré par :

Statistiques du serveur :

715
comptes actifs

mastouille.fr: À proposAnnuaire des profilsPolitique de confidentialité

Mastodon: À proposTélécharger l’applicationRaccourcis clavierVoir le code sourcev4.3.4

#mysql

2 messages2 participants0 message aujourd’hui
Public
Jonathan Kamens

#Perl DBD::mysql and the corresponding #RHEL package have always been #MariaDB compatible, i.e., you could install MariaDB and DBD::mysql RPMs together.
But the new DBD::mysql package in #CentOS stream can no longer be installed with MariaDB.
I filed a bug (issues.redhat.com/browse/RHEL-) and #RedHat said it's not supposed to work. Except it always has.
What do you think?
(Note if it doesn't work then all Perl scripts on the host that use DBD::mysql must be modified to use DBD::MariaDB instead.)
#mysql

· 21 personnes · Fermé
issues.redhat.comLoading...
Public
Parigot-Manchot φ

#Shaarli: How to Add Multiple Hosts in phpMyAdmin – TecAdmin - Méthode pour gérer plusieurs bases MySQL dans un même PhpMyAdmin.

Pour des bases en docker, installer le container PMA sur le même réseau docker et donner le nom du container pour afficher la base.

Permet en théorie de sélectionner des bases docker internes et des bases externes (hébergeur). : tecadmin.net/add-multiple-host #phpmyadmin #docker #bases #mysql

TecAdmin · How to Add Multiple Hosts in phpMyAdmin – TecAdminThis how to guide will help you to add multiple hosts ( database server ) in phpMyAdmin, So we can select to which database server we need to connect.
Public *
Julien Riou

Upgrade from MySQL 8.0.33 to 8.0.41 this morning on production.

Everything went smoothly... until:

Lock timeout when upgrading an intermediate primary in a ClusterSet. It looks like bugs.mysql.com/bug.php?id=1002. I know that kill -9 has been used in the past (yes, MySQL can be challenging and it's the only solution), so let's re-initialize the host. 6TB of data, it's going to be long but we have no choice at this point.

The Percona Server version of MySQL Shell doesn't support the Javascript interface anymore. The official documentation has Javascript examples everywhere but not Python. I had to guess and learn the Python equivalent in emergency.

Then if we define a "localAddress" to "Cluster.add_instance", MySQL tries to use the deprecated "XCOM" communication stack instead of "MYSQL". If you have errors on port 33061, you should remove the localAddress and/or use the "MYSQL" communication stack dev.mysql.com/doc/mysql-shell/

Every time the service is started, it takes 30 seconds to initialize the InnoDB buffer pool because the host has 1TB of RAM.

For an unknown reason, the mandb process takes multiple minutes when upgrading a package.

Time is really long when you do upgrades.

bugs.mysql.comMySQL Bugs: #100242: Upgrade from MySQL 8.0.16 to MySQL 8.0.18 failed
#mysql
Public
greub 🐑

Mon site web sur free a pété. Je ne sais pas trop ce qui s'est passé sur ma base SQL, mais toujours est-il que mes données sont pour partie perdues. Il s'agit d'un site de #généalogie perso accessible uniquement par moi et qui n'a pas vocation à être public. A votre avis, je change d'hébergeur pour passer sur une solution payante (laquelle?), une autre solution gratuite (laquelle?) ou je m'autohéberge sur un RaspberryPi ? #hebergement_web #PHP #MySQL #Webtrees

Public
Paul Kater

I am throwing a fit trying to get the python mysql-connector installed.

pip gives me an error:
error: externally-managed-environment

× This environment is externally managed

How do I get this thing installed? So many of my programs use this.

#python#mysql
Public
Negative12DollarBill

Hi, #Today I decided to try to #getfedihired — I've got many years of experience with web development, programming and production (#HTML, #CSS, #Javascript), I can make myself useful in anything on the open-source side of back end, i.e. the #Perl, #Python, #PHP, #MySQL, #Linux kind of area.

I live in #Sydney Australia and would be happy to work in-office, remote or hybrid.

Let me know of any opportunities, or pass this on to anyone else who might know of something? Thanks.

Public *
Pasquale 📷 🇫🇷 🦻

#question #bash #crontab #mysql :

j'ai un script qui fait

for db in database1 database2 database3;
do
echo $db
if [[ "$db" != "database2" ]]; then
echo "dumping database $db"
mysqldump -u $USER -p$PASSWORD --databases $db > $db.sql
fi
done

quand je le lance directement, pas de souci, ça fonctionne. mais en tâche #cron, rien, que dalle, que pouic, mon cul dans les orties.
et je ne vois pas pourquoi.

Une idée ?

Edit : La solution à mon problème ici par @Dominix :

mastodon.social/@Dominix/11413

Mastodondominix 🦇 (@Dominix@mastodon.social)@pasqualeberesti@piaille.fr ah, et aussi il faut que le script commence par #! /bin/bash
Public
randomTYPO3

💾 About database error "Row size too large"

MySQL and MariaDB database engines sometimes generate a "Row size too large" error when modifying the schema of tables with many columns. This document aims to provide a detailed explanation of this error and presents solutions for TYPO3 instance maintainers to fix it.

➡️ docs.typo3.org/c/typo3/cms-cor

docs.typo3.orgImportant: #104153 - About database error "Row size too large" — TYPO3 Core Changelog main documentation
#TYPO3#mysql#mariadb
ExplorerFlux en direct
À propos