Problem I have a stock install of Debian 11 (testing) with a brand new install of MariaDB (10.5.9-MariaDB-1), phpMyAdmin (5.0.4deb2) and Lighttpd (1.4.59). After adding a user and logging in, clicking on any database and the privileges tab renders the…
how can I set all records in the field "published"=0 whose date in field F12 is older than today? Unfortunately, the field F12 is not a DateTime field, but a string. Unfortunately, I can't change that. I have to convert…
My project https://simbiat.ru/fftracker has a table, that is a junction table containing IDs of achievements earned by each character ID. It works fine, but my concerns is its size: before optimization it was 6.1 GBs and after it - 4…
I'm trying to delete duplicate rows in a table. The email field needs to be be unique in the table for the code after it to run. Here's my code: DELETE FROM deleteRequests WHERE Email NOT IN ( SELECT MAX(Email)…
I've got a little problem with my database permissions. I created a user with literally no rights to test a database class I'm writing on my local machine. So now if I try to change the charset on an existing…
I have a concern about my MariaDB 10.4.12 database query execution time, which is getting much faster without any update to my database schema or data. While a speed-up is always welcome, I am concerned about the root cause of…
i have many to many relationship like this : Server version: 10.4.17-MariaDB table colors(id,name). table items(id,title....). table item_color(id,items_id,color_id). my query is like this : SELECT items.*,colors.name FROM items,item_color,colors where items.id = item_color.item_id and colors.id = item_color.color_id i use php function…
I removed mysql and installed mariadb, I guess removing mysql broke InnoDB (I'm new to this). InnoDB: Plugin initialization aborted with error Data structure corruption Full Log: -- Subject: Unit mariadb.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support…
everyone. Ive started to learn bash and DevOps, lost 2 days, but I cant understand the following: requirments Centos 7 DB mysql zabbix server version 4 mariadb I need to write bash script (script at the end of the question),…
I am installing Magento 2.4 on Vagrant through command line here is the error I got Current version of RDBMS is not supported. Used Version: 10.5.8-MariaDB-1:10.5.8+maria~bionic. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.4) and here is the configurations at my Homestead.yaml ip:…