Questions tagged [mariadb]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
31 views

MYSQL error reading communication packets

I get 2021-06-03 11:04:07 5559 [Warning] Aborted connection 5559 to db: 'mydbname' user: 'mydbusername' host: 'localhost' (Got an error reading communication packets) every 10 minutes in mysql log ...
0
votes
0answers
21 views

MariaDB Access Denied after Server Reboot

I'm using 10.3.29-MariaDB-0ubuntu0.20.04.1 and every time I reboot the server on my VM I get the error "Access denied for user 'root'@'localhost' (using password: YES)". I can reset the ...
0
votes
0answers
16 views

Install mysql-server 8 after mariadb-server 10 debian 10 buster on the same host

I've found some text to install mariadb-server alongside mysql-server 8, mariadb after mysql-server. I've not found any way to do the inverse. With mariadb-server installed on debian 4.19.0-16-amd64 #...
0
votes
0answers
24 views

MariaDB service fails to start with InnoDB Space id error

I've been running MariaDB on a Raspberry Pi 4 as the database server for my Webtrees and Owncloud sites. Recently, I noticed that the server wasn't looking right, and after a reboot, I can see that ...
0
votes
1answer
408 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 $...
0
votes
0answers
48 views

mariaDB service no longer works after upgrading from SuSE Linux Enterprise 12.1 to 12.3

I recently did an upgrade on a virtual machine running SuSE Linux Enterprise 12SP1 to SuSE Linux Enterprise 12SP3. On this server, I run an Apache server serving a Drupal Site, as well as a MariaDB ...
0
votes
0answers
330 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 |...
0
votes
1answer
1k 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 ...
0
votes
1answer
54 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 ...
0
votes
1answer
26 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, ...
0
votes
0answers
87 views

Opensuse Standard vs Port - which one to choose to install mariadb-connector-c

I knew that the openSUSE OS versions are either Tumbleweed or Leap. We have openSUSE Leap 15.1 installed. Here is the system information: NAME="openSUSE Leap" VERSION="15.1" ID=&...
0
votes
1answer
113 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
1answer
251 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/...
4
votes
1answer
707 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
51 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
15 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
291 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
213 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
54 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
30 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 ...
2
votes
1answer
733 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
187 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
89 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) .....
2
votes
2answers
2k 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
68 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
3answers
974 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
138 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
108 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
375 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
1answer
974 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
vote
1answer
2k 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
245 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
262 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
69 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
1answer
602 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
727 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
784 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
38 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
409 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
203 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
15 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
669 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
22 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
648 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
605 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
21 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
1k 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
2k 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
1k 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 ...
0
votes
1answer
4k views

Where to find libmyodbc5.so library after mysql-connector-odbc installation?

CentOs7 Want to connect my Asterisk installation with MariaDB via mysql-connector-odbc driver. yum list installed | grep maria MariaDB-client.x86_64 10.4.4-1.el7.centos @...