Mit „mysql“ getaggte Nachrichten

Former Bob Jonkman -- Please use the new server at https://gs.jonkman.ca Statusnet , System Administrators , balleyne

Thought I'd install #VirtualMin, but it ate my #MariaDB setup, tried to replace it with #MySQL, botched the installation, and I had to recover it all manually. Killed my !StatusNet daemons, had to #KickTheDaemons. Sorry for the interrupted service. !SysAdmin #Fail.

lnxw48 daw

@daw It has been years since I ran #MySQL on #Windows ( #WinXP ). Not sure anything is still relevant to current versions of MySQL or Windows.

lnxw48 jaywink

@jaywink@iliketoast.net That is *very* bad news. I switched completely to #MariaDB because #Oracle was making proprietary-like moves with #MySQL. In one step, MariaDB Corp has leapfrogged Oracle. I won't say they've gone #evil yet, but th…

lnxw48 dragnucs

@dragnucs Having said this, not being dependent on a single central organization is really important. If #Oracle evilizes #MySQL, #MariaDB's branch of the same codebase can avoid that. Or #Percona can revive its performance-enhanced branc…

lnxw48

#TIL: php-mysql-diff http://url.federati.net/lLY6h #mysql #mariadb

vsatayamas

Ajahn @pruet is plugging in #libthai to #MySQL for Thai full-text search.

lnxw48 daw , geniusmusing

@geniusmusing @daw As #MariaDB is my #MySQL distribution of choice, I'm familiar with that. Hopefully, they'll grow enough to eventually become the central project (leaving Oracle's version to become a distro of MariaDB). Other than that,…

lnxw48 daw

@daw Are we? I wasn't aware #Oracle had disgorged control of #Java, #MySQL, and #Solaris / #OpenSolaris into foundations outside ORCL control. They finally set #OpenOffice free, but in such a condition that it may not last much longer.

lnxw48 windigo , x11r5

@x11r5 Yes, but you still need to stay away from the #database. It takes too much of @windigo's time to fix #mysql / #mariadb after you break things.

pztrn mmn

@mmn Best way to achieve performance improvements on #mysql or #mariadb - use InnoDB and caching/threading features. Hints: innodb_buffer_pool_size, innodb_data_file_path, innodb_log_file_size, innodb_flush_log_at_trx_commit, innodb_thread_con…

lnxw48

#NoteToSelf: #MySQL / #MariaDB create database syntax with a particular charset and collation: https://fresh.federati.net/url/10722

lnxw48 espionage724

I've moved from #MySQL to #MariaDB before. That was trouble-free. I suspect that #Fedora's versions are somewhat newer than #Ubuntu's, so you probably will not have a problem.

lnxw48 nybill

@nybill I had to double the RAM on #DigitalOcean to keep #MySQL / #MariaDB from crashing and allow software updates to complete. Considering moving both droplets to a single #Linode (where I've never had that problem).

lnxw48

Went to check Denticator at http://url.federati.net/418Gt but #PHP and #MySQL are not talking. Error message "Fatal error: Call to undefined function mysql_connect() in /space/www/www.macno.org/denticator/functions.php on line 76"

mk mk

@mk After a lot of futzing around with phpMyAdmin I followed one suggestion I found: stopped #mySQL and made a backup of the database *files* (simple local rsync), then UNinstalled phpMyAdmin. Planning toe-install it I noticed ASUSTO…

lnxw48 vinilox

@vinilox Is #MySQL doing a lot of disk reading and writing? See http://url.federati.net/wfqhB #schemacheck

lnxw48

Due to the way #SSL implemented in #MySQL, downgrade and #MITM possible with all versions. Affects #MariaDB also, though they are patching 10.1.x (and possibly 10.0.x and 5.5.x). *Patches may break existing applications that depend on pri…

pztrn

Migrating #drupal database from #mysql to #postgresql. Feeling myself kinda better, IDK why.

lnxw48

#MySQL #database now has the ability to "autogenerate" columns from existing columns. http://url.federati.net/Jbrxs gives an example of use, but that example actually demonstrates that it should be possible to have case-sensitive and case…

lnxw48

Encrypting database tables or tablespaces with #MariaDB http://url.federati.net/HJ0D0 #MySQL