Running XAMPP with MySQL Here are exact step by step instructions for truly integrating MySQL into XAMPP on Windows. This has been successfully tested with Windows 10 and XAMPP 7.3.11 for both MySQL 8.0.18 and 5.7.28. Stop MySQL (which actually is MariaDB) in the XAMPP Control Panel. Download the MySQL community server as zip archive … Read more
Galera 10 cluster node dropping queries
The following would create the result I was after: SELECT LOWER(CONCAT( SUBSTR(HEX(uuid), 1, 8), ‘-‘, SUBSTR(HEX(uuid), 9, 4), ‘-‘, SUBSTR(HEX(uuid), 13, 4), ‘-‘, SUBSTR(HEX(uuid), 17, 4), ‘-‘, SUBSTR(HEX(uuid), 21) )) FROM foo;
In case you are bitten by this bug, the solution is given as a suggestion in the bug report (all of these have to be done as root, so either with sudo -i as a zeroth command or with sudo prefixed): echo “/usr/sbin/mysqld { }” > /etc/apparmor.d/usr.sbin.mysqld (the second part with sudo is … | … Read more
From the manual: The SELECT … INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT … INTO OUTFILE. In that case, … Read more
All my Laravel apps running PHP 7.2 had this error but those running on PHP 7.3 did not. So I changed the PHP version to 7.3 and the problem was fixed. (Running Laravel 7)
You can dump all results to the csv file without looping: rows = cursor.fetchall() fp = open(‘/tmp/file.csv’, ‘w’) myFile = csv.writer(fp) myFile.writerows(rows) fp.close()
Well, you can read about the differences in the documentation. I can’t tell you what you should be using because every project is different. 10.1.3 Collation Naming Conventions MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, followed by one or more … Read more
The problem is that – in Hibernate 5.x and earlier – the dialect org.hibernate.dialect.MySQLDialect is for MySQL 4.x or earlier. The fragment TYPE=MYISAM that is generated by this dialect was deprecated in MySQL 4.0 and removed in 5.5. Given that you use MariaDB, you need to use (depending on the version of MariaDB and – … Read more
These steps are working on CentOS 6.5 so they should work on CentOS 7 too: (EDIT – exactly the same steps work for MariaDB 10.3 on CentOS 8) yum remove mariadb mariadb-server rm -rf /var/lib/mysql If your datadir in /etc/my.cnf points to a different directory, remove that directory instead of /var/lib/mysql rm /etc/my.cnf the file … Read more