Category: MySQL
Anything related to the MySQL DBMS
Upgrading MySQL from 5.7 to 8.0
Upgrading MySQL from 5.7 to 8.0 was mostly uneventful.
Read More → Upgrading MySQL from 5.7 to 8.0Preparing to upgrade MySQL
You can’t configure nor download a newer version of the MySQL client using the FreeBSD ports collection while an older version is installed. It’s outrageous.
Read More → Preparing to upgrade MySQLPoststeder i Norge
Her er en oppskrift for å få alle Norges poststeder inn i en egnet tabell. Last ned Postnummerregister_ansi.txt fra Bring.
Read More → Poststeder i NorgeMySQL 5.7.12 refusing to run due to innodb_system data file ‘/var/db/mysql/ibdata1’ being too small
One of my MySQL 5.7.12 instances refused to start after upgrading to FreeBSD’s MySQL port version 5.7.12_1, claiming: 2016-05-18T11:03:26.688719Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file ‘/var/db/mysql/ibdata1’ is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages! “Googling” […]
Read More → MySQL 5.7.12 refusing to run due to innodb_system data file ‘/var/db/mysql/ibdata1’ being too smallBootstrapping MySQL 5.7 on FreeBSD
I tried a fresh install of MySQL 5.7 using ports on FreeBSD stable/10 the other day. All went smoothly until I needed to access the DBMS. The DBMS wouldn’t let me in, demanding a password I hadn’t set myself.
Read More → Bootstrapping MySQL 5.7 on FreeBSDMinor difficulties with PHP 5.3.5, php-mysql 5.3.5, and MySQL 5.5.8 on FreeBSD 8, now solved
Something was wrong with the combination of PHP 5.3.5, php-mysql 5.3.5, and MySQL 5.5.8 on FreeBSD 8 earlier this month. Any attempt to run the command php -v resulted in PHP hanging after outputting the “Zend line”. Either kill(1) the process or type C-c to put it out of its misery, but neither action is […]
Read More → Minor difficulties with PHP 5.3.5, php-mysql 5.3.5, and MySQL 5.5.8 on FreeBSD 8, now solved