There is a mariadb version 10.7 instance running in Kubernetes. Recently log-bin was added to the server.cnf. The restore scripts stopped working for any databa
Stack I am using: Python 3.10.x FastAPI 0.75.x SQLAlchemy 1.4.3x Summary I am building a unifying FastAPI project for several legacy databases (stored back-end
I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I
I have stored about 7 million biological protein sequences in text field of MySQL table (using InnoDB storage engine and latin1_swedish_ci collation). Sequence
I have two tables: The first one contains numeral values, it looks like this: The id column is the primary key; it has the attribute AUTO_INCREMENT. All col
I got this message when I try to run query on XAMPP in macOS #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, n
I want to create UserRole table, but mariaDB complains with the following error: Error Code: 1005. Can't create table `testdb`.`userrole` (errno: 150 "Foreign k
I cant connect java to MariaDB .I saw all similar questions answers but none has solved my problem. Here is my code : /** To change this license header, choose
According to MariaDB's website, you can simply replace MySQL with MariaDB. Great, I thought, however after installing MariaDB (10.5.7), some of my InnoDB tables
I want to create a database trigger that deletes automatically rows where the value of happened_at field is older than 15 days. My table rows id int(11) site_id
I am trying to install Mariadb on Debian but I am getting the error below when I try to install it. Mariadb was actually working for me for a while. I just tr
I'm using Fedora 29. I'm try to run mariadb.service with command:systemctl start mariadb, and give error:Failed to start mariadb.service: Unit mariadb.service n
I have the query below and it gives me a count of 32,000. SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationsh
I have question need to query from product table and have many variants and prices, how can I show like below product. variants. price ========================
I'm attempting to create an SQL query that retrieves the total_cost for every row in a table. Alongside that, I also need to collect the most dominant value for
I have one table that contains two columns: id (integer) list_colum (longtext) - contains json array (e.g. [1, 2, 3]) I want to select all records that have an
I tried out Docker with UFW and i read a lot of this. My goal was to connect to an mariadb database on the host machine from an docker image. Host (running u
I am using MariaDB version 10.2 I have an array of GUIDs stored as JSON in a table and I want to select rows from another table where the ID matches any of the
I have two only records in a database table and I want to delete only one of them. The problem is that I don't have any primary key nor unique identifier, so ho
How do i bulk insert multiple records in 1 query so my db will be efficient I want to create Office and insert multiple new equipments into that office. Table/m