pouet.chapril.org est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Chapril https://www.chapril.org est un projet de l'April https://www.april.org

Administré par :

Statistiques du serveur :

1,1K
comptes actifs

#mysql

6 messages5 participants0 message aujourd’hui
Izoate<p>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.</p><p>Read the full guide: <a href="https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">izoate.com/blog/how-to-fix-mys</span><span class="invisible">ql-error-1175-disable-safe-update-mode-mysql/</span></a></p><p><a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/Error1175" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Error1175</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDev</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DevTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevTips</span></a> <a href="https://mastodon.social/tags/SafeUpdateMode" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SafeUpdateMode</span></a> <a href="https://mastodon.social/tags/MySQLTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQLTips</span></a> <a href="https://mastodon.social/tags/izoate" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>izoate</span></a> <a href="https://mastodon.social/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://mastodon.social/tags/technology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technology</span></a> <a href="https://mastodon.social/tags/howto" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>howto</span></a></p>
Leanpub<p>PHP &amp; MYSQL: 200 Solved Exercises and Projects for Practice <a href="https://leanpub.com/php-mysql-exercices-projects" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">leanpub.com/php-mysql-exercice</span><span class="invisible">s-projects</span></a> <a href="https://mastodon.social/tags/books" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>books</span></a> <a href="https://mastodon.social/tags/ebooks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ebooks</span></a> <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> <a href="https://mastodon.social/tags/MYSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MYSQL</span></a></p>
Flasche_Chris (Chrissy)<p>Question, my colleague want's a small database with only a few tables ( <a href="https://social.tchncs.de/tags/Mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Mariadb</span></a> / <a href="https://social.tchncs.de/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://social.tchncs.de/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> ) - Data pushed with PowerShell Scripts</p><p>He also wants a small Web UI to search in this database with "basic" filtering</p><p>I've found <a href="https://social.tchncs.de/tags/Adminer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Adminer</span></a> (<a href="https://www.adminer.org/de/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">adminer.org/de/</span><span class="invisible"></span></a>) which looks simpler then things like phpMyAdmin</p><p>Is this a good choice ? thx</p>
freespirit利努克斯 :debian:<p>Open Source Linux MySQL Tools!</p><p>Was ist MySQL?</p><p>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.</p><p><a href="https://www.linuxlinks.com/mysqltools/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">linuxlinks.com/mysqltools/</span><span class="invisible"></span></a></p><p><a href="https://mast.linuxat.de/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://mast.linuxat.de/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>linux</span></a> <a href="https://mast.linuxat.de/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://mast.linuxat.de/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://mast.linuxat.de/tags/freiheit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>freiheit</span></a> <a href="https://mast.linuxat.de/tags/keinmicrosoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>keinmicrosoft</span></a></p>
Julien Riou<p>My hot take: if you chose MySQL in 2025, you are doing it wrong. Just Use Postgres™</p><p><a href="https://hachyderm.io/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://hachyderm.io/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a></p>
Julien Riou<p>Upgrade from MySQL 8.0.33 to 8.0.41 this morning on production.</p><p>Everything went smoothly... until:</p><p>Lock timeout when upgrading an intermediate primary in a ClusterSet. It looks like <a href="https://bugs.mysql.com/bug.php?id=100242" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">bugs.mysql.com/bug.php?id=1002</span><span class="invisible">42</span></a>. 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.</p><p>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.</p><p>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 <a href="https://dev.mysql.com/doc/mysql-shell/8.0/en/shell-admin-api-communication-stack.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.mysql.com/doc/mysql-shell/</span><span class="invisible">8.0/en/shell-admin-api-communication-stack.html</span></a></p><p>Every time the service is started, it takes 30 seconds to initialize the InnoDB buffer pool because the host has 1TB of RAM.</p><p>For an unknown reason, the mandb process takes multiple minutes when upgrading a package.</p><p>Time is really long when you do upgrades.</p><p><a href="https://hachyderm.io/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a></p>

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

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.

Some thoughts on my preliminary investigation of #Omeka ( omeka.org/classic/docs/Install ).

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.

omeka.orgInstallation - Omeka Classic User Manual

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.