Questions tagged [mariadb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
87 views

Mariadb: store databases in alternative location [closed]

I'd like to store my MariaDB databases in a location other than the default (/var/lib/mysql). I've created a folder /home/kst/mysql for this. I then stopped mariadb and I've edited the datadir line in ...
The-Rest-Is-Noise's user avatar
1 vote
2 answers
730 views

Updating Connector/Python for Python 3.11

Having moved to Python 3.11, I need to update Connector/Python - which requires the MariaDB Connector/C library. This library is normally installed with python -m pip install mariadb But I'm getting ...
tyddynonn's user avatar
1 vote
0 answers
337 views

Install latest MariaDB properly via apt

Currently I'm running this helper function in my synced shell environments on all my Linux/macOS devices; install_mariadb() { local mariadb_version_test local mariadb_version local ...
Fëanorson's user avatar
0 votes
0 answers
288 views

MySQL service is missing

In my raspberry pi 400, I'm trying to install phpMyAdmin. I don't know why but I think mysql service is missing. If I try to run sudo apt-get dist-upgrade I get the following error: pi@raspberrypi:~ $ ...
Adrian Hernando Solanas's user avatar
0 votes
0 answers
103 views

Raspberry PI 4 SQL Database receiving old data

Im having a strange issue. I have always connected to a DB at the start, then querried as needed. However for some reason if I have my database connection outside my loop I am not reading in the ...
Kevin Lay's user avatar
1 vote
1 answer
45 views

Raspberry PI 3 mariaDB and python issue with expanding columns

I am having an issue that I don't really have programming experience to resolve. I have an application that deploys an SQL table that may have more or less columns depending on user input. I am ...
Kevin Lay's user avatar
1 vote
1 answer
619 views

Build MariaDB 10.5 on Raspberry Pi 3B Unable to find a source package for mariadb-server

I am wanting to build MariaDB 10.5.5 on my Raspberry Pi 3B (Kernel version 5.4.65-v7+) since it has some nice features I want to play with. The first step involves setting up the build environment ...
A Dark Divided Gem's user avatar
1 vote
1 answer
102 views

Problem with mariaDB, HSF+ and Raspbian on a Raspberry Pi 4

I'm making a full LAMP using a Raspberry PI 4 w/ 4GB RAM, Apachie2, MariaDB 10.3.22 and PHP and a 4 Teribite HSF+ USB drive. Initial setup worked fine till I attempted to change to data store of ...
Gary Scott's user avatar
2 votes
1 answer
108 views

Importing Data from MFRC522 to MariaDB via. raspberry pi 3

can you please assist me on python scripts that can import DATA FROM AN RFID READER (MFRC522) TO A MariDB DATABASE using a Raspberry Pi 3 B+?
Ak282616's user avatar
1 vote
1 answer
164 views

Migrating MariaDB from Stretch to Buster

I am currently in the process of migrating my ownCloud from my old Pi 3B to a Pi 4B. On the 3, I made a backup of my MariaDB with mysqldump: mysqldump --single-transaction --routines --triggers --all-...
Clashsoft's user avatar
  • 121
1 vote
1 answer
368 views

Use actual MySQL on Raspbian Stretch instead of MariaDB

I have a web based project which I wrote with NodeJS. I moved the project to my Raspberry Pi which runs on Raspbian Stretch. The project has a lot of lines of code which deal with MySQL connections. ...
RishiC's user avatar
  • 143
1 vote
3 answers
3k views

How do I build Qt's mysql-plugin on Raspbian Buster

I try to build the MySQL plugin on a Raspbian Buster with C++ and Qt 5.12.4. Building Qt itself worked fine by following this tutorial: https://www.tal.org/tutorials/building-qt-512-raspberry-pi ...
elnacho's user avatar
  • 43
-1 votes
1 answer
2k views

installation error mariadb-server

i've previously installed mariadb successfully on my raspberry pi (raspian stretch lite). however i wanted to completely reinstall mariadb and also delete the old databases. i did this with the ...
user103591's user avatar
1 vote
1 answer
65 views

Install Raspbian with all settings

Is it possible to install Raspbian with all settings as I want them, with scripts and GUI I have programmed and with MariaDB with all necessary tables? So the next time it boots it is ready as the ...
Stefan Bahrawy's user avatar
0 votes
1 answer
2k views

can't install mariadb 10.1 on raspbian stretch

after several attempts to install mariadb on Raspbian stretch i am still stuck on the same error: Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job for mariadb.service failed because the ...
Nicolas's user avatar
0 votes
0 answers
374 views

Mounted USB to SSD drive locks up

I am using a Raspberry Pi 3 B+ with the official charger running Raspbian Stretch Lite (Debian Version 9.4, Kernal 4.14.34-v7+ #1110) with MariaDB (Version 10.1.23) and I am trying to import a 52GB ...
A Dark Divided Gem's user avatar
2 votes
1 answer
7k views

Connection to MySQL database does not work

I have two Raspbery PI 3 which I have installed (almost) identical. The configuration of /etc/mysql/mariadb.conf.d/50-server.cnf is identical for both Raspberrys. Problem: I can only connect to the ...
Michael Hutter's user avatar
1 vote
1 answer
534 views

Python reads 'ä','ü','ö' and 'ß' wrong out of MariaDB [closed]

I read a message out of my Database like this: import MySQLdb db = MySQLdb.connect(host="localhost", user="?", passwd="?", db="?") cur = db.cursor() message = cur.execute("SELECT Nr, Nachricht ...
Simon Ber's user avatar
5 votes
1 answer
15k views

MySQL initial installation

I know there are many, many threads on this, but hear me out before marking it as a duplicate. On an Raspberry Pi running stretch installed mysql sudo apt-get install mysql-server No errors pi@...
Chad G's user avatar
  • 1,043