Join us on Wednesday 16th April for our Scaling Writes on MySQL event!
https://www.meetup.com/leedsphp/events/306614649/
#php #MYSQL #db #leedsphp
Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.
Read the full guide: https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/
PHP & MYSQL: 200 Solved Exercises and Projects for Practice https://leanpub.com/php-mysql-exercices-projects #books #ebooks #PHP #MYSQL
Question, my colleague want's a small database with only a few tables ( #Mariadb / #mysql #sql ) - Data pushed with PowerShell Scripts
He also wants a small Web UI to search in this database with "basic" filtering
I've found #Adminer (https://www.adminer.org/de/) which looks simpler then things like phpMyAdmin
Is this a good choice ? thx
Open Source Linux MySQL Tools!
Was ist MySQL?
MySQL ist ein weit verbreitetes, relationales Datenbankmanagementsystem (RDBMS), das auf der Structured Query Language (SQL) basiert. Es wird häufig für die Speicherung, Verwaltung und Abfrage von Daten in verschiedenen Anwendungen eingesetzt, von kleinen Websites bis hin zu großen Unternehmensanwendungen.
My hot take: if you chose MySQL in 2025, you are doing it wrong. Just Use Postgres™
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 https://bugs.mysql.com/bug.php?id=100242. 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 https://dev.mysql.com/doc/mysql-shell/8.0/en/shell-admin-api-communication-stack.html
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.
Hoy fueron buena onda en la uni y nos dieron una herramienta libre llamada HeidiSQL para aprender sobre creación de procedimientos en SQL.
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.
CookUnity is hiring Engineering Manager, Growth
#kotlin #swift #typescript #react #android #ios #aws #mysql #postgresql #engineeringmanager
Buenos Aires, Argentina
Full-time
CookUnity
Job details https://jobsfordevelopers.com/jobs/engineering-manager-growth-at-cookunity-com-dec-19-2024-4107a2?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Migrating your #OpenProject installation?
From Docker to packages, older setups to the latest version, or even switching databases — it’s important to understand your options.
Our latest blog article outlines best practices and recommended paths to guide you through:
https://www.openproject.org/blog/migration-installation-guide/
Debugging PHP App Engine Applications Locally: A Guide to Troubleshooting MySQL Connections
Debugging App Engine PHP deployments with MySQL often involves local environment discrepancies. Connection failures, like "No such file or directory," happen when your local setup doesn't match App Engine's Cloud SQL Proxy. Learn how to emulate the App Engine environment locally using the Cloud SQL Auth Proxy to fix these issues. #AppEngine #PHP #MySQL #Deployment #Troubleshooting #CloudSQL #GoogleC...
Connecting to Databases with Python jaydebeapi: A Comprehensive Guide
Learn how to connect to databases using Python's jaydebeapi library. This powerful tool bridges Python with Java Database Connectivity (JDBC), enabling access to various databases like MySQL and Oracle. Perfect for when native Python drivers aren't available. #Python #Databases #Jaydebeapi #JDBC #MySQL #Oracle
https://tech-champion.com/programming/connecting-to-databases-with-python-jaydebeapi-a-comprehensive-guide/
...
How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...
Anyone know if it’s possible to migrate a #SQLite @forgejo #forgejo database to #PostgreSQL or #MySQL?
Grrr, why don't you support having a MySQL flexible server on a Virtual Network with ipv6 Azure?
This isn't the year 2000 any longer.
Automatisches MySQL-Backup per Script
heute möchte ich dir ein nützliches Bash-Script vorstellen, das dich dabei unterstützt, automatische Backups deiner MySQL-Datenbanken zu erstellen. Das Script habe ich für meine persönlichen Bedürfnisse geschrieben. Jedoch möchte ich es gerne mit d...
https://www.techniverse.net/blog/2025/03/automatisches-mysql-backup-per-script/
#Linux #Automatisierung #Backup #bash #Datenbanksicherung #Datenverlust #ITSicherheit #mysql #script #Sicherungskopien
Some thoughts on my preliminary investigation of #Omeka ( https://omeka.org/classic/docs/Installation/Installing/ ).
Built on pretty standard #LAMP stack.
No official docker image that I could find, so of course I built my own.
Which reminded me why I HATE php.
Anyway.
Some light testing (running locally).
Pretty simple to use (good).
No fancy ideas about creating "presentation" versions of items, and keeping the original upload "pristine". I am of two minds on this - for now, not a problem for me, but I can see how large archives might be problematic.
For example, a MOV file needs to be presented as a MP4 for widest audience. And you probably don't want to lose the original.
With Omeka that means some manual work on the admin side.
It support plugins and themes - I'm of two minds here also. Good way
to extend functionality and allow for customization, but my experience with such things are not good ito longterm stabililty and maintenance.
I'm also not super keen on #MySQL as the db, due to recent corruptions issues with my #Nextcloud instance (moved that to #PostgreSQL ).
BUT, this will be read heavy, so maybe not an issue - hard-ish to corrupt a db by reading from it.
The useage of #DublinCore at least means (I think) in theory, if I really want, I should be able to migrate to another Dublin Core compatible system if needed. So...good.
My verdict - I'm going to play with it some more.
Install some plugins etc, see what happens.
I'm also building up a test set of assets, in case I want to eval something else.
Qiita - 人気の記事 
