Questions tagged [mariadb]
SQL database that can be used as a "drop-in" replacement for MySQL
116
questions
1
vote
1
answer
67
views
Running mariadb on alpine container
I'm attempting to run mariadb on an alpine:latest (asof 20231027; 20230901; 3.18.4) container. Forgive a n00b, but I've always run it on a host system that comes with it pre-installed.
I ran ...
- 13
0
votes
0
answers
97
views
Connect to a remote MariaDB server using VirtualMin
I have a web server but wish to locate a separate server for MariaDB. I'm following this tutorial but there's no "Module Config" under Webmin -> Servers -> MariaDB Database Server. ...
- 1
0
votes
0
answers
44
views
Virtualmin configuration error after updates
I updated my VPS which I administer with Virtualmin, it runs Ubuntu 20.0.4.6
When rechecking the configuration, it stops at:
A problem was found with your Postfix virtual maps :
The map source mysql:/...
- 1
1
vote
0
answers
306
views
Connect to MariaDb datasource in Power Bi
I have successfully connected to my MariaDb/MySQL datasource in Power Bi Desktop using the Oracle MariaDB ODBC connector.
I use Import mode to be able to model the imported data in Power Bi. So far, ...
- 428
0
votes
1
answer
258
views
mariadb 10.1: Access denied for user, from ipv6 only
Adding an access record with host %, or with host smtp.acme.com does not provide access when accessing via IPv6. Nor does using the specific IPv6 address. I only get 'access denied'.
The SQL server is ...
- 211
1
vote
1
answer
376
views
How can I add 2 missing nodes to a galera cluster that has one node that is accepting reads and writes?
I am running a galera cluster with 3 nodes, having 3TB of data.
Last night due to a short power cut and a faulty UPS I completely lost 2 of the nodes and everything in /var/lib/mysql folder.
At this ...
2
votes
1
answer
445
views
With DBeaver connecting to MariaDB, how to keep the session alive?
DBeaver uses MariaDB Connector/J, and the driver disconnects after completing the query.
We are trying to use a MariaDB feature that depends on the session, so we need to run the query and keep the ...
- 299
0
votes
0
answers
20
views
How can I connect a preinstalled MariaDB instance to XAMPP-Control-Panel?
Since I have already a MariaDB instance, FileZilla and Perl on my PC I installed XAMPP with these programs. Now I'm wondering how can I connect MariaDB and FileZilla to the XAMPP control panel to make ...
- 101
1
vote
0
answers
455
views
Unable to get mariadb to get bound on localhost
On my remote Ubuntu 20.04 server I have an instance of mariadb running.
I can access this server through SSH with user myuser and open run the CLI-client on the server to open a prompt for the ...
1
vote
1
answer
1k
views
MariaDB: Should I configure the db-server using "/etc/my.cnf" or a file in "/etc/my.cnf.d"?
I am trying to configure MariaDB on a machine with Fedora 37: Workstation as its operating system.
I expected to use /etc/my.cnf to configure the ports and such, however, the file contained an include ...
- 818
1
vote
1
answer
298
views
Why can't I connect to my MariaDB server from my mac, but I can connect from a Docker container on the same machine?
I have set up a MariaDB server on db.bestalbumsintheuniverse.com, port 6612. I have the following situation from the command line on my local laptop (macOS):
$ mysql -h db.bestalbumsintheuniverse.com -...
- 111
0
votes
2
answers
427
views
Create a MySQL database backup on a daily basis and keep only last N copies
A common issue for administrators. I have a database that I want to make a daily backup. Also, I want to keep only last week n copies.
Do you have any recommendations based on essential Linux commands?...
- 131
2
votes
2
answers
822
views
MariaDB --tc-heuristic-recover in Docker container
I have a MariaDB database in a docker container for my home automation (homeassistant). For some reason it stopped working and I get this error in the docker system logs:
221001 12:27:03 mysqld_safe ...
- 31
0
votes
1
answer
42
views
Differences between the zone info SQL files generated on different RHEL hosts
We want to install time zone data in MariaDB using mariadb-tzinfo-to-sql. The process roughly includes:
Generating an SQL file from the files in /usr/share/zoneinfo of the Red Hat Enterprise Linux 7 ...
- 299
1
vote
0
answers
57
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 ...
2
votes
1
answer
2k
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
[email protected] ...
- 121
0
votes
1
answer
3k
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 ...
- 1
2
votes
1
answer
554
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;
+---------------+-----------+----------------------...
- 131
0
votes
0
answers
238
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 ...
0
votes
1
answer
495
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 ...
- 1
0
votes
1
answer
1k
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 (...
- 707
0
votes
1
answer
5k
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
$...
- 103
0
votes
0
answers
894
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 |...
- 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 ...
- 11
0
votes
1
answer
2k
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 ...
1
vote
1
answer
2k
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, ...
- 13
0
votes
1
answer
122
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 ...
1
vote
1
answer
397
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/...
- 13
4
votes
1
answer
4k
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
...
- 303
0
votes
0
answers
116
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 ...
- 1
0
votes
1
answer
80
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 ...
- 399
0
votes
3
answers
2k
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?
- 889
0
votes
1
answer
529
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:
# ...
- 801
0
votes
0
answers
91
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, ...
- 1
0
votes
0
answers
43
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 ...
- 9
2
votes
1
answer
3k
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://...
- 21
0
votes
0
answers
515
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 ...
1
vote
0
answers
167
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) .....
- 11
2
votes
2
answers
4k
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:...
- 31
1
vote
0
answers
274
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 ...
- 11
0
votes
3
answers
3k
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 ...
- 143
1
vote
1
answer
370
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 ...
- 11
0
votes
1
answer
375
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 ...
- 1
1
vote
0
answers
407
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 ...
- 11
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-...
- 1
4
votes
1
answer
5k
views
Why !includedir means import file?
cat /etc/mysql/mariadb.cnf
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/ ...
- 121
1
vote
1
answer
357
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 ...
- 13
0
votes
1
answer
356
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....
- 1
1
vote
1
answer
149
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 ...
- 111
0
votes
1
answer
1k
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 ...
- 101