On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last checkpoint is X, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least … Read more
On a Cpanel server, when running “yum update”, I got the error message “One of the configured repositories failed (MariaDB100)”. [root@cp ~]# yum update Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds from cached hostfile * EA4: 178.18.193.52 * cpanel-addons-production-feed: 178.18.193.52 * cpanel-plugins: 178.18.193.52 * base: centos.uni-sofia.bg * extras: centos.uni-sofia.bg * updates: centos.uni-sofia.bg http://yum.mariadb.org/10.0/centos7-amd64/repodata/repomd.xml: [Errno 14] … Read more
To change the MariaDB root password, log in to MySQL as the user root mysql -u root -p Enter your current password when prompted. Use the following command to change the root password SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘NEW_PW_HERE’); Replace NEW_PW_HERE with your new MySQL root password. Change a user password SET PASSWORD FOR ‘USER_HERE’@’localhost’ … Read more
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 following error boby@sok-01:/www/magento/amazingplans/backup$ mysql amazingplans < amazingp_demo.sql ERROR 1005 (HY000) at line 4080: Can't create table `amazingplans`.`catalog_product_relation` (errno: 140 "Wrong create options") boby@sok-01:/www/magento/amazingplans/backup$ On checking the line in the error message, I found ... Read more
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. To increase value for open_files_limit, create file mkdir /etc/systemd/system/mariadb.service.d/ vi /etc/systemd/system/mariadb.service.d/limitnofile.conf Add [Service] LimitNOFILE=1048576 Reload systemctl systemctl daemon-reload Restart mariadb systemctl restart mariadb After doing this, it get changed to 32184 instead of … Read more
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 and MariaDB version you need. Below you will see instructions for your specific version of CentOS. Install MariaDB 10.5 on CentOS 7 CentOS 7 by default provide MariaDB 5.5. To install MariaDB 10.5 … Read more
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 created worked fine. Only root user had this error. To fix, you need to enable auth_socket.so plugin. Edit file vi /etc/mysql/mariadb.conf.d/50-server.cnf Find [mysqld] Add below plugin-load-add = auth_socket.so Resatrt MariaDB systemctl restart mysqld … Read more
When restoring a MySQL database, i get error “MySQL server has gone away”. # mysql -u root -p’serverok123′ sok_wp < backup.sql ERROR 2006 (HY000) at line 5095: MySQL server has gone away # To fix this, edit MySQL configuration file. Add following line under [mysqld] section. max_allowed_packet = 256M Restart MySQL systemctl restart mysql If ... Read more
On my computer running Ubuntu 18.04, MriaDB stopped working. PHP application i run on my computer failed with error SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ok_test.feeds’ doesn’t exist (SQL: select * from `feeds` where `processed` = 0) Application can’t find the table. So i tried to login to MySQL and see if … Read more
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 on CentOS 7, create a file vi /etc/yum.repos.d/MariaDB.repo Add [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 Install the MariaDB server and client with yum install MariaDB-server MariaDB-client Enable MariaDB to start … Read more
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:~# mysql -u vcon_user -p vcon_sbc < vcon_sbc.sql Enter password: ERROR 1064 (42000) at line 287: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version ... Read more
MariaDB Repository Setup Script MariaDB DEFAULT NULL ERROR 1064 (42000) Install MariaDB 10.3 on CentOS 7