Questions tagged [mariadb]

SQL database that can be used as a "drop-in" replacement for MySQL

Filter by
Sorted by
Tagged with
1 vote
0 answers
24 views

Is there any reasons for using MySQL over MariaDB? [closed]

this is the first time that I ask a question here. Is there any reasons for using MySQL over MariaDB ? I am currently using MariaDB (Everywhere home and pro) since Debian (Stretch) is no longer ...
user avatar
1 vote
0 answers
67 views

Can't start mariadb service with brew in mac

I am trying to start mariaDB in mac with brew services. I run brew services stop --all jenkins-lts none mariadb none memcached none mysql none mysql@5.7 ...
user avatar
0 votes
0 answers
13 views

Trying to install MariaDB installs Mysql instead on Fedora 33

I have a PC running Fedora 33 with MySQL installed. I need to install MariaDB as well but since it is a fork from MySQL, when i execute: sudo dnf install MariaDB-server It shows me that MySQL is ...
user avatar
0 votes
1 answer
546 views

Running MariaDB in a container with storage through NFS

I'm trying to run a MariaDB container on a raspberry pi. The container is created through docker-compose and to persist the data I want to use my NAS. To mount a directory from the NAS to the ...
user avatar
1 vote
1 answer
125 views

Why is MariaDB using localhost when using TCP?

I installed MariaDB via Nix and I am having trouble connecting via TCP. I have users such as: MariaDB [(none)]> SELECT User, Host FROM mysql.user; +---------------+-----------+----------------------...
user avatar
  • 121
0 votes
0 answers
71 views

Failed to connect to MySQL: (2002) No such file or directoryError: // MariaDB issue?

--Apologies in advance. Not a coder, but have gotten this far with the assistance of v helpful people on forums such as this-- I've had a VM instance running on GCP with no issues for a couple of ...
user avatar
0 votes
0 answers
46 views

mariadb find overlapping date ranges

I have a mariadb table of approximately 12M rows. Fields within each row contain a timestamp for the start time and end time for a process. The timestamps are actually seconds since the Linux epoch. ...
user avatar
  • 411
0 votes
0 answers
31 views

Is total MySQL memory usage scaled by innodb_buffer_pool_instances?

I seem to remember reading somewhere that: Total InnoDB pool usage = innodb_buffer_pool_size * innodb_buffer_pool_instances but I can't find the original reference. Is this true? or true for certain ...
user avatar
  • 319
0 votes
0 answers
41 views

Mariadb use HSM instead of private key files for server side ssl/tls

There seems to be 0 support for instructing the mariadb server to use a pkcs11 interface instead of using a private key file. I'd like to have mariadb talk to an HSM to establish incoming secure ...
user avatar
0 votes
0 answers
29 views

MariaDB: How do I load a copy of a table into RAM for frequent reading?

Colleagues, tell me how to keep a copy of the table in RAM? I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
user avatar
  • 1
0 votes
0 answers
30 views

Cannot run maria db container in raspberry pi due to 2038 date error

I am trying to setup home assistant with docker on my raspberry pi 4. I have installed raspberian. Here is my docker-compose file:- version: '3' services: homeassistant: container_name: hass ...
user avatar
0 votes
1 answer
375 views

Php Extension MySqli installed but calling it gives an error

I run the following statements (so it is completely reproducible) (because i wanted to play with the source code of WordPress) and the following makes your current dir a website running under 8082 (...
user avatar
  • 667
0 votes
1 answer
2k views

How to set up an SQL database on Synology NAS?

I would like to set up REST API, which can communicate with my database on my NAS. I made this simple PHP code for the database connection, and it works perfectly with Xampp on my computer. <?php $...
user avatar
  • 3
0 votes
0 answers
603 views

Start mySQL docker container with existing InnoDB Database failing on startup

I'm testing the workflow to start a mySQL Docker Container with an existing InnoDB directory. This was pretty much rsync'ed from a remote server. I tried MariaDB with the following result: db_mariaDB |...
user avatar
  • 103
0 votes
1 answer
2k views

Error for remove mysql-server-8.0 on linux system

Hello my mysql install is broken i can't uninstall or reinstall them i'm stuck. Os: POP Os 20.04 LTS Mysql: mysql Ver 8.0.21-0ubuntu0.20.04.4 for Linux on x86_64 ((Ubuntu)) Problem I have ...
user avatar
  • 11
0 votes
1 answer
399 views

How to increase MariaDB memory from my.cnf?

I'm using Centos 7 and trying to increase MariaDB memory and performance and as I read before here I need to increase the innodb_buffer_pool_size but I can't find it in "/etc/my.cnf" file ...
user avatar
0 votes
1 answer
187 views

Understanding versioning with MySQL and MariaDB?

I'm trying to understand the relationship between MySQL versions and MariaDB versions and hoping someone can clarify? I was under the impression that MariaDB was forked from MySQL many years ago and, ...
user avatar
0 votes
1 answer
115 views

The SQL statement to check "~ is in or not"

I'd like make the right table from the left table on MySQL. enter image description here SELECT A.id AS id, B.name AS name, A.name as loca FROM tst A, tst B WHERE A.id = B.loca; But, This can not ...
user avatar
1 vote
1 answer
275 views

MariaDB will not start using bind mounts

Fresh install MariaDB on freshly installed Kubuntu 20.04. After successfully setting up MariaDB with the "stock" databases, it was running fine. Then I moved and renamed the original contents of /var/...
user avatar
  • 13
4 votes
1 answer
2k views

How to recover and restore a MariaDB database from a broken CentOS 7 system?

In a Virtual Box VM I had CentOS 7 server installed in a VDI HDD and for some reason “Something I did obviously…” I cant boot the machine with the messages bad magic number you need load the kernel ...
user avatar
  • 118
0 votes
0 answers
70 views

Slow write performance of MariaDb with data directory outside root partition

My application suffers from slow write actions into a MariaDB when the data directory of the server is on a different disk partition then the root partition. I use a Raspberry Pi 3 with Raspbian ...
user avatar
0 votes
0 answers
21 views

mariadb: table not viewable from user root

With adminer, user root, in debian busters, a table in a mariadb database isn't read: Why cannot I see the table UserHistory like the others? I suppose that the mariadb root user has all the ...
user avatar
0 votes
3 answers
684 views

MariaDB on MacOS: where is the default ibdata1 file?

Using Homebrew, I install MariaDB. It installs fine, but where is the ibdata1 file stored?
user avatar
  • 879
0 votes
1 answer
268 views

Installing MariaDB 10.4 on Centos 7

I am experiencing some trouble with installing MariaDB 10.4 on Centos 7. The official mariaDB guide says that a new repo file MariaDB.repo should created in /etc/yum.repos.d/ with the contents of: # ...
user avatar
  • 761
0 votes
0 answers
64 views

I broke logging in MariaDB; How to repair?

I messed up. In order to save disk space, I removed mysql-000xx.bin files with Ubuntu's rm command - rather than using the mysql purge command, as I later found out. But the damage is done now, ...
user avatar
0 votes
0 answers
35 views

Send an image to my database server

I am currently working on a webscraper that downloads an image and its title, description etc. from a website. The device that runs the scraper programm is my raspberry pi. I want to store the image ...
user avatar
  • 9
2 votes
1 answer
2k views

Can not start MariaDB service on windows 10 machine although I have full admin rights

At work I have to use Windows 10 for the first time and I am having a hard time starting a service. I downloaded the latest version of MariaDB as a .zip from the official homepage at: https://...
user avatar
0 votes
0 answers
286 views

Mariabackup creates huge incremental database backups

I’ve been using these commands to create a full: mariabackup --backup --target-dir=/home/ubuntu/mariaDB-backup/2019-10-07_13:57:03-full --user=NOTSHOWN --password=NOTSHOWN And this to create a ...
user avatar
1 vote
0 answers
118 views

mariadb-server-10.1 fails to install on MX Linux

Trying to install mysql-server which requires mariadb. However, my package manager fails as soon as it gets to mariadb-server-10.1 with the errors: Setting up mariadb-server-10.1 (10.1.41-0+deb9u1) .....
user avatar
2 votes
2 answers
3k views

MariaDB is not running, but PID file exists

I have an issue with MySQL. Although it looks like MySQL is able to start on my server: service mysql start Starting MariaDB.190930 03:56:09 mysqld_safe Logging to '/var/log/mysqld.log'. 190930 03:56:...
user avatar
1 vote
0 answers
187 views

phpmyadmin not working after php verion Update

I have VPS with below things installed Nginx, PHP 7.2.22, 10.3.18-MariaDB Recently Updated PHP version from 7.1.17 to 7.2.22 .. After this, website is working fine.. PHPMyAdmin set on custom ...
user avatar
0 votes
3 answers
2k views

Can I update / delete / insert database records via power query?

So I use Get & Transform (fka Power Query) in Office 365 / Excel 365 to query a MariaDB database (equivalent to MySQL in this case). Given that I have the database permissions to do so, can I ...
user avatar
1 vote
1 answer
227 views

How to add existing DBase to phpmyadmin

We use phpmyadmin (4.6.6deb5) to admin some MariaDB-databases (10.1.38-MariaDB-0ubuntu0.18.10.2 - Ubuntu 18.10) which are added and design by phpadmin. Now we add a database and a user by using the ...
user avatar
0 votes
1 answer
213 views

SQL data not displaying properly when selecting multiple columns

When I run the following code, I get garbled output MariaDB> select c.customer_id,c.name,o.order_name from customers c left join orders o on c.customer_id = o.customer_id; When I just select a ...
user avatar
  • 1
1 vote
0 answers
392 views

Latest version of MariaDB 10.4.7 does not launch on Windows 10

I have been using MariaDB locally on my machine for development purposes using the extracted zip version (e.g. mariadb-10.3.17-winx64.zip). This has worked flawlessly while on 10.3.x Have attempted ...
user avatar
0 votes
1 answer
2k views

Replication Error: 'Binary log is not open'

Heyho, I'm trying to set up a basic database replication from a MariaDB 5.5 master to a MariaDB 10 slave. Versions are non-negotiable, since I need the older version on the master and a multi-...
user avatar
1 vote
1 answer
3k views

Why !includedir means import file?

cat /etc/mysql/mariadb.cnf # Import all .cnf files from configuration directory !includedir /etc/mysql/conf.d/ ...
user avatar
  • 87
1 vote
1 answer
304 views

Cannot install RMariaDB on Ubuntu 18.04

I have tried many things and this is the error i get. It is similar when i try to install both RMariaDB and RMysql. g++ -std=gnu++11 -shared -L/usr/lib/R/lib -Wl,-Bsymbolic-functions -Wl,-z,relro -o ...
user avatar
0 votes
1 answer
298 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
user avatar
1 vote
1 answer
90 views

Make MariaDB run on boot without networking

I am running a timer python program I made on a raspberry pi with raspbian. The idea is for the timer to start when the pi boots (systemd) and stop when the pi is unplugged. It saves to a MariaDB ...
user avatar
  • 111
0 votes
1 answer
799 views

Connecting to a SQL database using a UDL

I am attempting to connect to a remote SQL server (MariaDB running on a Linux machine) on port 3308 using a UDL / data link file, since that is what another program I am using requires. However, I ...
user avatar
0 votes
1 answer
883 views

MariaDB, tomcat connection pool access denied Error

First of all, I am sorry, I am not good at English. Hi! I have some problems about connecting mariaDB from Java web project using tomcat connection pool and JNDI. Here are Exception logs from ...
user avatar
0 votes
1 answer
1k views

Mariadb failover issue with a master/slave configuration

We have a replication (GTID based) setup as described below: ms1 = master mariaDB server (v. 10.3.13) ms2 = slave mariaDB server (v. 10.3.13) ms3 = MaxScale proxy (v. 2.3.8) >root@ms3 ~ # ...
user avatar
0 votes
1 answer
102 views

Issue changing column names when using Spoon/Kettle

I'm using Spoon (version 8.2) and I'm having an issue changing column names in a MySQL Query. For example, if I use this query: Select col1 AS ID, col2 AS Name ... FROM mytable; It returns rows ...
user avatar
0 votes
0 answers
467 views

MySQL/MariaDB won't start

I recently updated mariadb on my server from the debian repository and now the sql server won't start. I think there could be a conflict with old packages as a result of the update, but am not sure ...
user avatar
0 votes
0 answers
266 views

MariaDB ERROR 2006 (HY000) only in information_schema database

I had a MariaDB server running fine on CentOS 7. I did a mysqldump and imported it on a different machine running the same software. I tried to query in "information_schema," and I got the following: ...
user avatar
  • 1
0 votes
1 answer
17 views

systemctl and where programs are installed

I am on an amazon linux instance that is based afaict on centos : e.g. I have used sudo yum install -y mysql and sudo yum install -y postgresql While these did install without errors I do not ...
user avatar
1 vote
1 answer
882 views

*** buffer overflow detected *** in mariadb 10.3.11

We are getting Assertion failure every time memory usage of MySQL spikes up to overall system's memory. Every time Assertion failure reports different file in code location "/home/buildbot/buildbot/...
user avatar
1 vote
0 answers
28 views

Restoring InnoDB-Table does not work

i have some issue while restoring data from ibd and ibdata-file. I had worked with these instructions, Recovering A Corrupt MySQL Database and it worked fine until I took a look at the data. The ...
user avatar
0 votes
0 answers
924 views

How to restore corrupted .IDB files on a MySQL server?

I currently have all the old .frm and .idb files from a MySQL server (actually the entire data directory). The server itself has been deleted by the user in his troubleshooting and he has installed a ...
user avatar