Questions tagged [mariadb]
MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.
mariadb
14,478
questions
1
vote
0
answers
16
views
Is it possible for PHP/PDO/MySQL to perform a transaction on its own?
I have ZERO transaction code in my PHP script. That was done on purpose. My application is too simple to need it.
Starting less than a week ago, without any code changes on my part, records written to ...
0
votes
1
answer
26
views
An efficient way to insert data into MariaDB [duplicate]
I have an API, created with TypeScript and Node.js which is connected to the MariaDB database. For database communication I am using „mariadb“ package.
One of the calls accepts payload with the data, ...
- 3
-1
votes
0
answers
55
views
Using PHP/PDO/MySQL: Records have started vanishing (literally) without changes to the code [closed]
I assume whoever closed this because it "lacked detail or clarity" didn't actually read the whole thing. Or, perhaps, thought I was just an idiot.
I know, the subject line makes no sense -- ...
0
votes
1
answer
58
views
SQL - Display 0 on a count with months where there is no data
I hope someone can help.
I have been attempting to tackle this problem for some time. I have two tables "admissions" and "month data".
The admissions table contains the two fields &...
0
votes
1
answer
30
views
System.NotSupportedException: Versions of MySQL prior to 5.6 are not currently supported
I am not able to connect to MariaDB with EF. I am using libraries:
MySql.Data v9.0.0
MySql.Data.EntityFramework v9.0.0
MariaDB version: 10.5.8-MariaDB-log
My app.config
<entityFramework>
&...
- 2,159
1
vote
0
answers
18
views
How to disable binary logs in RDS using MariaDB?
I am using MariaDB 10.11 on Amazon RDS and want to disable binary logs.
I created a custom parameter group but can't find the appropriate option. It seems that MySQL binary logs can be disabled using ...
- 1,378
2
votes
1
answer
46
views
Using REGEXP or REGEXP_SUBSTR in an MariaDB query to extract all of the image source links
I'm trying to use REGEXP in an MariaDB 11.0.2 query to extract all of the image source links within the HTML and text of the field post_content that is in each row in wp_posts. I've looked at related ...
- 656
3
votes
2
answers
91
views
concat two column in mysql , one of them is an auto-increments, using trigger
Dears, please below is my first trigger to make a column as a concat a two column .. but it is not working ?! can i know where is the error
create table `concatcolumn`(
`id` int(10) ...
- 33
-1
votes
0
answers
14
views
Fixing the server restart problem for MySQL database replication using XAMPP
So, I have successfully created a Master-Slave replication between 2 machines using XAMPP. There are a few problems I am facing:
1- Each time I try to see the logs in the Master, the position changes, ...
0
votes
1
answer
26
views
At MariaDB database suddenly huge number of bin log file generated
I found almost 13830 update rows found like below in each bin logs files. But there are only a few update queries at each log.
This command shows only 85 update query
mysqlbinlog mysql-bin.005400 | ...
0
votes
1
answer
43
views
mariadb ssl problem: ERROR 2026 (HY000): TLS/SSL error: Validation of SSL server certificate failed
this will be extremely detailed as I can't solve this problem. I have a website developed with java servlet and jdbc, whose connection method is:
private static synchronized Connection ...
-1
votes
0
answers
10
views
MariaDB Database with name #mysql50#.java
In a MariaDB Server only used for an older JavaEE Application with Glassfish 5.1 and Eclipselink 2.8 suddenly appeard a database named
#mysql50#.java
I dont't know how this could happen.
I was able to ...
- 1
0
votes
1
answer
38
views
Mariadb / mysql EXPLAIN to optimize data query
I am using mariadb to store a large number of measurements. A common query I do selects for a data range. It takes a little long, something like 10 to 20 seconds, and it gets worse and worse, so I was ...
- 13
0
votes
0
answers
43
views
INSERT only if row with specific conditions does not exist - with some concerns about concurrency and atomicity
I need to insert a row in a table only if a row with a specific set of conditions is not already found in that table.
Given that this problem is (extremely) common, I searched through answers and came ...
- 309
-1
votes
0
answers
18
views
I have installed AWS ami ec2 instance, when I try to install packages show error Last metadata expiration check
I have installed AWS ami ec2 linux instance on AWS, when I try to install mariadb then show the error last metadata expiration check. how can i resolve this isssue?
#!/bin/bash
DATABASE_PASS='admin123'...
- 1