How to fix InnoDB: ERROR: the age of the last checkpoint
On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last…
mariadb
One of the configured repositories failed (MariaDB100)
On a Cpanel server, when running “yum update”, I got the error message “One of the configured repositories failed (MariaDB100)”. [root@cp ~]#…
Change MariaDB user password
To change the MariaDB root password, log in to MySQL as the user root mysql -u root -p Enter your current password…
Can’t create table `catalog_product_relation` (errno: 140 “Wrong create options”)
When I try to restore the MySQL database of a Magento 1.x site on MariaDB 10.3.32 (source MySQL 5.7.36), I get the…
MariaDB Change Open Files Limit
When using systemctl, you can set value for open_files_limit in my.cnf file. Default installation of MariaDB 10 have open_files_limit set to 16384.…
Install Latest MariaDB on CentOS
To install the latest MariaDB on the CentOS server, go to https://mariadb.org/download/?t=repo-config On this page, select CentOS, then select your CentOS version…
MariaDB ERROR 1524 Plugin unix_socket is not loaded
After upgrading MariaDB on Ubuntu server, i got following error root@server:~# mysql ERROR 1524 (HY000): Plugin ‘unix_socket’ is not loaded root@server:~# Users…
MySQL server has gone away
When restoring a MySQL database, i get error “MySQL server has gone away”. # mysql -u root -p’serverok123′ sok_wp < backup.sql ERROR…
Ubuntu 18.04 MariaDB 10.2 Too many open files
On my computer running Ubuntu 18.04, MriaDB stopped working. PHP application i run on my computer failed with error SQLSTATE[42S02]: Base table…
Install MariaDB 10.3 on CentOS 7
MariaDB is an Open Source MySQL drop-in replacement. MariaDB provides a repository for various operating systems at https://mariadb.org/download/?tab=repo-config To install MariaDB 10.3…
MariaDB DEFAULT NULL ERROR 1064 (42000)
When trying to restore a MySQL databse bakcup taken on MySQL 5.7 server to MairaDB 10.1 server i get following error. root@server:~#…
MariaDB
MariaDB Repository Setup Script MariaDB DEFAULT NULL ERROR 1064 (42000) Install MariaDB 10.3 on CentOS 7