Questions tagged [mariadb]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
112 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 ...
0
votes
0answers
50 views

When trying to install MySQL client, I got this error

ERROR: Command errored out with exit status 1: command: 'c:\users\xbox\appdata\local\programs\python\python38-32\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\...
1
vote
1answer
216 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/...
3
votes
1answer
100 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 ...
0
votes
0answers
34 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 ...
0
votes
0answers
21 views

Debian 10 Mariadb libmysql client version update not possible

we are running an MariaDb Database and using php5.6 I just want now to upgrade the old Database Client version libmysql - mysqlnd 5.0.11-dev - 20120503 to a newer. So I can't see one in my Debian 10 ...
0
votes
0answers
20 views

How to grand remote connecting access to mariadb?

I am trying to remote connect to a MariaDB via a ssh tunnel but get timeouts. Connecting via telnet from the remote machine works. root is there: SELECT User, Host FROM mysql.user; | root | ...
0
votes
0answers
14 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 ...
0
votes
2answers
51 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?
0
votes
1answer
177 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: # ...
0
votes
0answers
23 views

What is the default configuration for MariaDB 10.3 on RHEL?

We are using MariaDB 10.3 on RHEL 7. Recently we have done MariaDB upgrades and perhaps our current configuration is out of date with the newest default distribution config files. How could I find ...
0
votes
0answers
47 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, ...
0
votes
0answers
29 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 ...
0
votes
0answers
13 views

Replace master server in replication enviroment

I have a setup with one master mysql server and three read-only slaves (all mariadb 5.5 on centos 7). Now I want to move the master server to a new hardware, so I need to replace the old master with ...
2
votes
1answer
225 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://...
0
votes
0answers
127 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
0answers
68 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) .....
0
votes
1answer
1k 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:...
1
vote
0answers
40 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 ...
0
votes
0answers
233 views

MariaDB getting error “1038 - Out of sort memory, consider increasing server sort buffer size” when sorting on TEXT field

I am a developer. I am working with Wordpress on a dedicated server with CENTOS 7 and MariaDB 10.2.27. In certain situations, when using the ORDER BY statement, the server returns the [Err] 1038 - ...
0
votes
2answers
127 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 ...
1
vote
1answer
55 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 ...
0
votes
1answer
49 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
vote
0answers
312 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 ...
0
votes
0answers
205 views

MariaDB 10.4.7 consume all memory

I have the following problem - when I start to do multi-inserts, MariaDB starts to take up permanent memory until it consumes all the available memory and the server blocks. Even if the load is low, ...
0
votes
0answers
162 views

MariaDB/Galera SST sync, foreign key issue?

I am having a bit of an issue with a MariaDB Galera cluster. Its a two node cluster, was going to increase to three soon. Two servers: ptdb01 ptdb02 The ptdb01 server left the cluster for some ...
0
votes
1answer
298 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-...
0
votes
0answers
120 views

MariaDB performance degradation over time

Technical Info Version: 10.4.7-MariaDB-1:10.4.7+maria~xenial my.cnf show create table Hardware Intel(R) Xeon(R) CPU E5-1650 v3 @ 3.50GHz 128GB RAM ECC DDR4 435GB SSD disk Small description When ...
0
votes
1answer
586 views

Why !includedir means import file?

cat /etc/mysql/mariadb.cnf # Import all .cnf files from configuration directory !includedir /etc/mysql/conf.d/ ...
1
vote
1answer
124 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 ...
0
votes
1answer
236 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
vote
1answer
43 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 ...
0
votes
0answers
43 views

Two different version of MariaDB on server, but only need one. CentOD 7 / Plesk

I have inherited a CentOS 7 server running Plesk and wordpress install. I am attempting to enable the mariadb server to be accessible remotely, however I am getting lots of inconsistencies. When ...
0
votes
0answers
10 views

Need help about MariaDB always stop to run

I don't know why, my server MariaDb always stop to run each day. I tried many solution here but the problem still there. I can't see why and this is my recent log: > 190718 08:58:09 mysqld_safe ...
0
votes
0answers
31 views

Server slows down for 2-3 minutes randomly around 3 times per week

What is the best way to identify the reason for a random slow-down of a server? I'm running an eCommerce website, with traffic mainly coming from facebook and google ads (avg online 200 users), every ...
0
votes
1answer
240 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 ...
0
votes
1answer
387 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 ...
0
votes
1answer
454 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 ~ # ...
0
votes
1answer
26 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 ...
0
votes
0answers
315 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 ...
0
votes
0answers
155 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: ...
0
votes
1answer
14 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 ...
1
vote
1answer
392 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/...
1
vote
0answers
14 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 ...
0
votes
0answers
382 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 ...
0
votes
1answer
334 views

MariaDB won't work after moving database to external drive

Problem: MariaDB doesn't work after moving database to new location. Context: Connected external hard drive (NTFS) to Raspberry Pi and moved all MariaDB database files to folder on external drive, ...
0
votes
0answers
18 views

Is it possible on mariadb/mysql to snapshop the db and revert it back later?

I know I can do a backup and revert it, but the goal is to use it for debug. I work with Drupal and often I have to debug code that will create/delete/edit data in the database, and then I have to ...
1
vote
0answers
757 views

Installing NextCloud on Windows (IIS/PHP/MariaDB) [closed]

I'm having some problems installing NextCloud on Windows 10/2016... I'd tried also installing under XAMPP but NextCloud keeps failing to start... Anybody has some info/tutorials or know where to go ...
0
votes
1answer
1k views

MariaDB Server cannot start: “InnoDB: No valid checkpoint found.”

After my VM server has fully crashed, and I do not know why, MariaDB on this Debian cannot be launched again. Content of error.log with log files: 2019-04-15 0:40:43 139787712552320 [Note] InnoDB: ...
0
votes
0answers
729 views

Testlink new installation “DB Access Error - debug_print_backtrace() OUTPUT START”

Testlink error When I try to install Testlink on Workbench, this error occurs: DB Access Error - debug_print_backtrace() OUTPUT START ATTENTION: Enabling more debug info will produce path ...