Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
universeodon.com is part of the decentralized social network powered by Mastodon.
Be one with the #fediverse. Join millions of humans building, creating, and collaborating on Mastodon Social Network. Supports 1000 character posts.

Administered by:

Server stats:

3.5K
active users
Learn more

universeodon.com: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.2.17

#mysql

14 posts12 participants4 posts today
Daniel Brendel<p>Sometimes mysql shuts down unexpectedly when using with XAMPP. </p><p>There is a workaround here to solve this:<br><a href="https://stackoverflow.com/a/61859561" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">stackoverflow.com/a/61859561</span><span class="invisible"></span></a></p><p>Kinda cool to create an AquaShell script to automate that task:</p><p><a href="https://www.aquashell-scripting.com/examples#fix-xampp-mysql-shutdown-error" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">aquashell-scripting.com/exampl</span><span class="invisible">es#fix-xampp-mysql-shutdown-error</span></a></p><p><a href="https://mastodon.social/tags/scripting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>scripting</span></a> <a href="https://mastodon.social/tags/shell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>shell</span></a> <a href="https://mastodon.social/tags/admin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>admin</span></a> <a href="https://mastodon.social/tags/xampp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>xampp</span></a> <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/cmd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cmd</span></a> <a href="https://mastodon.social/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdev</span></a></p>
Jobs for Developers<p>CookUnity is hiring Engineering Manager, Growth</p><p>🔧 <a href="https://mastodon.world/tags/kotlin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>kotlin</span></a> <a href="https://mastodon.world/tags/swift" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>swift</span></a> <a href="https://mastodon.world/tags/typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>typescript</span></a> <a href="https://mastodon.world/tags/react" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>react</span></a> <a href="https://mastodon.world/tags/android" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>android</span></a> <a href="https://mastodon.world/tags/ios" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ios</span></a> <a href="https://mastodon.world/tags/aws" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aws</span></a> <a href="https://mastodon.world/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.world/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.world/tags/engineeringmanager" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>engineeringmanager</span></a><br>🌎 Buenos Aires, Argentina<br>⏰ Full-time<br>🏢 CookUnity</p><p>Job details <a href="https://jobsfordevelopers.com/jobs/engineering-manager-growth-at-cookunity-com-dec-19-2024-4107a2?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jobsfordevelopers.com/jobs/eng</span><span class="invisible">ineering-manager-growth-at-cookunity-com-dec-19-2024-4107a2?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting</span></a><br><a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobalert</span></a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobsearch</span></a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hiring</span></a></p>
OpenProject<p>Migrating your <a href="https://fosstodon.org/tags/OpenProject" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenProject</span></a> installation?</p><p>From Docker to packages, older setups to the latest version, or even switching databases — it’s important to understand your options.</p><p>Our latest blog article outlines best practices and recommended paths to guide you through:<br>🔗 <a href="https://www.openproject.org/blog/migration-installation-guide/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">openproject.org/blog/migration</span><span class="invisible">-installation-guide/</span></a></p><p><a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a> <a href="https://fosstodon.org/tags/Installation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Installation</span></a> <a href="https://fosstodon.org/tags/Docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Docker</span></a> <a href="https://fosstodon.org/tags/Packages" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Packages</span></a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/Helm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Helm</span></a> <a href="https://fosstodon.org/tags/Kubernetes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Kubernetes</span></a></p>
Federico Razzoli<p>The EXPLAIN command has been extended in different ways by <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a> and <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a>. See which options you have on these fantastic systems!<br><a href="https://vettabase.com/the-explain-command-and-its-variants-in-mariadb-and-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vettabase.com/the-explain-comm</span><span class="invisible">and-and-its-variants-in-mariadb-and-mysql/</span></a></p>
zartom<p>Debugging PHP App Engine Applications Locally: A Guide to Troubleshooting MySQL Connections<br>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. <a href="https://mastodon.social/tags/AppEngine" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AppEngine</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> <a href="https://mastodon.social/tags/Deployment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Deployment</span></a> <a href="https://mastodon.social/tags/Troubleshooting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Troubleshooting</span></a> <a href="https://mastodon.social/tags/CloudSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CloudSQL</span></a> <a href="https://mastodon.social/tags/GoogleC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GoogleC</span></a>...</p>
zartom<p>Connecting to Databases with Python jaydebeapi: A Comprehensive Guide<br>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. <a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.social/tags/Databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Databases</span></a> <a href="https://mastodon.social/tags/Jaydebeapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jaydebeapi</span></a> <a href="https://mastodon.social/tags/JDBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JDBC</span></a> <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/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Oracle</span></a><br><a href="https://tech-champion.com/programming/connecting-to-databases-with-python-jaydebeapi-a-comprehensive-guide/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">connecting-to-databases-with-python-jaydebeapi-a-comprehensive-guide/</span></a><br>...</p>
zartom<p>How to Change Column Collation in MySQL<br>Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands &amp; automation tips! <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/Collation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Collation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</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/CharacterSet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CharacterSet</span></a> <a href="https://mastodon.social/tags/UTF8MB4" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UTF8MB4</span></a><br><a href="https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/mys</span><span class="invisible">ql/how-to-change-column-collation-in-mysql/</span></a><br>...</p>
Rad Web Hosting<p>How to Install <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> 8 on <a href="https://mastodon.social/tags/VPS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>VPS</span></a> Server </p><p>This article provides a guide for how to install <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> 8 on VPS server.</p><p>Database Management Systems (DBMSs)&nbsp;are applications designed to store and organize data in an organized fashion, usually as part of an e-commerce or data warehousing application. One such DBMS is MySQL, an open-source and highly scalable free DBMS that's free and open source; we will cover how to install MySQL 8 onto a VPS server so you ...<br>Continued 👉 <a href="https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.radwebhosting.com/how-to-</span><span class="invisible">install-mysql-8-on-vps-server/?utm_source=mastodon&amp;utm_medium=social&amp;utm_campaign=ReviveOldPost</span></a></p>
beltrachi<p>Attending FOSDEM is always a pleasure, and this year I've summarized my findings/highlights in a post. I hope you like it!<br><a href="https://beltrachi.github.io/2025/03/05/fosdem-2025.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">beltrachi.github.io/2025/03/05</span><span class="invisible">/fosdem-2025.html</span></a> <a href="https://mastodon.social/tags/fosdem2025" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fosdem2025</span></a> <a href="https://mastodon.social/tags/vitess" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>vitess</span></a> <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/openapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openapi</span></a> <a href="https://mastodon.social/tags/asyncapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>asyncapi</span></a> <a href="https://mastodon.social/tags/survivorbias" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>survivorbias</span></a></p>
Christiaan Kras<p>Anyone know if it’s possible to migrate a <a href="https://fosstodon.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <span class="h-card" translate="no"><a href="https://floss.social/@forgejo" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>forgejo</span></a></span> <a href="https://fosstodon.org/tags/forgejo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>forgejo</span></a> database to <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> or <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a>?</p>
David Goodwin<p>Grrr, why don't you support having a MySQL flexible server on a Virtual Network with ipv6 Azure? </p><p>This isn't the year 2000 any longer.</p><p><a href="https://fosstodon.org/tags/IPV6" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IPV6</span></a> <a href="https://fosstodon.org/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a></p>
ChillinPanda<p>Ma quanto stracazzo è bello insegnare <a href="https://livellosegreto.it/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a>, <a href="https://livellosegreto.it/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> e <a href="https://livellosegreto.it/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a>?!</p><p>For non-Italian friends: How freaking cool is it to teach <a href="https://livellosegreto.it/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a>, <a href="https://livellosegreto.it/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a>, and <a href="https://livellosegreto.it/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a>?!</p>
Christian Mayer<p>DBeaver — Universal Database Tool — <a href="https://dbeaver.io/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">dbeaver.io/</span><span class="invisible"></span></a> <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/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</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/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://mastodon.social/tags/erd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>erd</span></a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
DeManiak 🇿🇦<p>Some thoughts on my preliminary investigation of <a href="https://mastodon.africa/tags/Omeka" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Omeka</span></a> ( <a href="https://omeka.org/classic/docs/Installation/Installing/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">omeka.org/classic/docs/Install</span><span class="invisible">ation/Installing/</span></a> ).</p><p>Built on pretty standard <a href="https://mastodon.africa/tags/LAMP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LAMP</span></a> stack. <br>No official docker image that I could find, so of course I built my own.<br>Which reminded me why I HATE php.</p><p>Anyway.</p><p>Some light testing (running locally).<br>Pretty simple to use (good).<br>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.</p><p>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. <br>With Omeka that means some manual work on the admin side.</p><p>It support plugins and themes - I'm of two minds here also. Good way<br>to extend functionality and allow for customization, but my experience with such things are not good ito longterm stabililty and maintenance.</p><p>I'm also not super keen on <a href="https://mastodon.africa/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> as the db, due to recent corruptions issues with my <a href="https://mastodon.africa/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Nextcloud</span></a> instance (moved that to <a href="https://mastodon.africa/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> ).<br>BUT, this will be read heavy, so maybe not an issue - hard-ish to corrupt a db by reading from it.</p><p>The useage of <a href="https://mastodon.africa/tags/DublinCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DublinCore</span></a> 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.</p><p>My verdict - I'm going to play with it some more. <br>Install some plugins etc, see what happens.<br>I'm also building up a test set of assets, in case I want to eval something else.</p><p><a href="https://mastodon.africa/tags/Selfhosted" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Selfhosted</span></a> <a href="https://mastodon.africa/tags/DigitalArchiveManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DigitalArchiveManagement</span></a></p>
Upscene Productions<p>Video: Creating an <a href="https://mstdn.business/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> database with tables and foreign key relationships.<br><a href="https://www.youtube.com/watch?v=w88NySp6Ydk" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=w88NySp6Yd</span><span class="invisible">k</span></a></p><p><a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a><br><a href="https://mstdn.business/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a><br><a href="https://mstdn.business/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a><br><a href="https://mstdn.business/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Oracle</span></a><br><a href="https://mstdn.business/tags/Firebird" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Firebird</span></a><br><a href="https://mstdn.business/tags/InterBase" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>InterBase</span></a><br><a href="https://mstdn.business/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a><br><a href="https://mstdn.business/tags/NexusDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NexusDB</span></a><br><a href="https://mstdn.business/tags/databasetools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databasetools</span></a> <a href="https://mstdn.business/tags/databasedevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databasedevelopment</span></a> <a href="https://mstdn.business/tags/DatabaseWorkbench" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseWorkbench</span></a></p>
dominik schwind

Okay, I'm a bit stumped. I have a small-ish ubuntu VM with the LAMP stack. Sometimes MySQL just goes away. No information why - not in the MySQL logs, not in syslog, nowhere. It just shuts down. It doesn't seem to be memory either, I've once had htop running while it happened and the machine was basically idle with more than half of the memory empty.

The most infuriating thing is: I had this on another VM before, I fixed it and I didn't write down how. Ugh.

#apache#linux#php
ollibaba

Huh... mysql-connector-python has changed the API for cursor.execute() in an incompatible way between versions 9.1.0 and 9.2.0 (by removing the "multi" parameter)? Without deprecation phase? And the documentation (dev.mysql.com/doc/connector-py) still states that it returns an iterator but actually one needs to call fetchall()?
Did not expect or desire this kind of yak shaving on a Saturday morning :-/

dev.mysql.comMySQL :: MySQL Connector/Python Developer Guide :: 9.3 Executing Multiple Statements
#mysql#python#swdev
ExploreLive feeds
About