I migrated my data to M1 Monterey MacOS from intel macmini. I was happy to use django and mariadb until I installed a package using homebrew. I installed homebr
Database : Maria DB 10.6.5 Issue: Data transfer from partitioned table to Non-Partitioned table Table A - partitioned on Date (range partitioned) Table B - Not
Database : Maria DB 10.6.5 Issue: Data transfer from partitioned table to Non-Partitioned table Table A - partitioned on Date (range partitioned) Table B - Not
I need to run the mysqld_safe command in a MariaDB installation, but I cannot find it inside the \bin folder...
I have this on a MariaDB version 5.5.65 datetimeconnect datetimeend queue agent event 02/05/2022 10:02:31 02/05/2022 10:02:31 "5009" "Mikey Blogs" "ADDME
pod logs: 2022-01-04 10:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.7.1+maria~focal started. 2022-01-04 10:43:14+00:00 [Note] [En
i'm facing a question without answer. I can't understand why the auto generated index from the FK creation is not working when the column seems to be the first
def getLevels(userName, levelID, levelName, levelLength, coins, starStars, amognus): try: statement = "SELECT userName, levelID, levelName, levelLength, coins
I read this post and I wish to fix it the same way as the answers but I can't find the backup folder in my CentOS. Where is C:\xampp\mysql\backup\ located in Li
I have MariaDB on my server with 16/32 CPU cores, Everything seems to be ok when running mysqltuner except InnoDB Write Log efficiency, taking 1953.15%, wonderi
Data I have a couple of tables like so: CREATE TABLE cycles ( `cycle` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cycle_type` varchar(140) COLLATE
I'm trying to replace an expensive where in ... query with a CTE. I've done this previously in other sql dialects, but can't get the syntax right for MariaDB/My
I have a 'locations' table as follows: Using an API, if I send a valid record, the table will start normally with index 1. If I send something that won't be ac
When connecting to an aurora db using the mariadb java client (version 2.7.5) i am getting this error (I only put the first few lines because the entire stack i
I'm trying to do pagination, but the SQL query returns the same values on different pages. I show them the queries and the results, and it shows that there are
Trying CONVERT() Trying STR_TO_DATE() Trying CAST() - neither DATE or DATETIME work Trying CAST(STR_TO_DATE()) Hi, I cannot figure out what I'm doing wrong with
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing
When the DB transaction is timeouted the transaction is still active and seems to only finish executing after PHP transaction timeout If I lock the table outsid
I have been trying to set up Chamilo using LEMP stack (Linux, Nginx, MariaDB, PHP 7) on CentOS 7 using this link https://www.digitalocean.com/community/tutorial
I have specific error when I'd like to add FULLTEXT INDEX to column street. My code is below. ALTER TABLE offer_private_14 ADD FULLTEXT INDEX idx_street (street