Questions tagged [mysql]
MySQL 8.0 is End Of Life on April 30, 2025. MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
8,796 questions
Score of -1
0 answers
40 views
What Could Cause an InnoDB .frm and .ibd File Mismatch [closed]
On June 3rd we noticed that one of our tables was not showing up in SHOW TABLES, but a direct SELECT * FROM table_name returned data normally.
When we ran FLUSH TABLES the select command stopped ...
Score of 1
1 answer
85 views
MySQL does not respond to TCP connections from network namespaces in Linux
I'm trying to access my MySQL database server from a Linux network namespace called application, using a veth pair named veth-application-root and veth-application-ns, located in root and in the ...
Score of 4
2 answers
313 views
How do I get Amavisd to use MariaDB, rather than MySQL
I have a server with Plesk installed and have been happily using amavisd to watch over my email systems. However, a recent update has caused a problem with this process. My server uses MariaDB for ...
Score of 0
0 answers
57 views
Mysql / Mariadb Federated Table Creation Statement Truncating Host Name
I am attempting to create a federated table on a mariadb host at 192.168.254.118 with a mysql server on 192.168.254.185. I can connect to 192.168.254.185 from 192.168.254.118 with no problem using the ...
Score of 0
2 answers
383 views
Django db backup with cron job
I am looking to set up database backups for my Django application, which uses MySQL.
I was trying to create a cron job that ran manage.py dumpdata. It looked like this:
0 18 * * * python3 /home/my-...
Score of 1
0 answers
348 views
Multiple Package Errors Trying to Update Oracle Linux 9 with Maria DB
We have a bunch of Oracle Linux 9 machines, many of which have MariaDB installed. It was originally installed via dnf (using ansible)
- name: Install mariadb (mysql)
dnf:
name:
- "...
Score of 0
1 answer
364 views
Bitnami Redmine Plugin Removal
I posted this to Bitnami Github help but so far no response and so I am trying here if someone could help.
https://github.com/bitnami/vms/issues/1877
Environment:
Linux 6.1.0-39-amd64 Debian 6.1.148-...
Score of 0
1 answer
251 views
backing up a mariadb database and recreating indexes on restoration
We are running mariadb:
Server version: 10.5.27-MariaDB-log MariaDB Server
and we need to backup a database named sports and on restoration "rebuild" all its indexes.
For mysql AI suggest to ...
Score of 3
0 answers
265 views
Migration of dictionary configuration with message's count and storage limits (plugin: quota/quota-imap) in mysql/mariadb - backend
I'm having a major problem converting my Dovecot configuration file to version 2.4.x. What I'm struggling with is using a dictionary to handle quotas within the MySQL backend (dict - plugin - Dovecot)....
Score of 1
1 answer
229 views
mariabackup --prepare keeps backup state at "log-applied", not "full-prepared"
I'm performing a full backup on a MariaDB 10.6.8 instance on linux and encountering an issue where the --prepare step finishes successfully but fails to transition the backup state to full-prepared. ...
Score of 1
0 answers
511 views
Is mariadb-secure-installation still relevant?
I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...
Score of 1
0 answers
116 views
server's temporary partition being in read-only mode
I’m running a WHM server and need to create a backup. However, my server administrator informed me that some files on the server are corrupted. I also have a very large MySQL database (around 450 GB).
...
Score of 0
0 answers
1513 views
Upgrading mysql to from 8.0 to 8.4 failed
I've an old server on Ubuntu 20.4 which is at EOL and just upgraded to Ubuntu 24 LTS via do-release-upgrade. I'm trying to upgrade all the current packages from focal(20) to noble(24) and was able to ...
Score of -1
1 answer
222 views
SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem' after Debian 9 (stretch) to 10 (buster) upgrade
Upgraded Debian Linux 9 (stretch) to 10 (buster).
Now I get the following error:
SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem'
The detailed status message is:
systemctl ...
Score of 1
1 answer
307 views
How to map per-user quota with Dovecot quota plugin using MYSQL dict?
Problem:
doveadm quota get -u <username> result shows that my MYSQL dict is not correctly mapped to Dovecot quota plugin, as a result IMAP QUOTA capability (with usage and limit) not being ...