As far as I know the timestamp column is internally stored in UTC. When selecting records, the utc value is automatically changed in the server's timezone, which in my case is Europe/Amsterdam. What if I do change the datatype of the column to DateTime, does it automatically update the value from UTC to Europe/Amsterdam also? Or, does it mean the UTC datetime is stored and I need to manually update it? Thanks in advance. submitted by /u/PossessionUnique828 [visit reddit] [comments ..read more

I need to do some dump/restore activity for which of course the server must be up. However, during this time I don't want it to accept any connections except on the local Unix socket that is used by the maintenance user to ensure DB consistency. Is there a way to do that? I know the REAL solution is to cleanly shut down all services that might want to use the database. But it's a somewhat messy intranet implementation with several people / applications involved, none of which have a proper "down for maintenance" page. So I'll just screw it and eat an hour of http server errors. submitted by ..read more

I'm aware that this topic has been very well documented over the past 10 years, and there are many good step-by-step descriptions on how to do the migration. (By forces outside my control I recently migrated from RHEL7 to RHEL8 which is why I'm many years behind the curve.) All of them use a common procedure, which is basically: Backup DB data dir Mysqldump all DBs Drop all DBs (except mysql) Stop server Delete ibdata1 and logfiles Start server Restore DBs by importing dumped SQL from step 2. I understand all of this. However, In this StackExchange post, I found this: By using the command ..read more

Hello, I am using mariadb odbc 3.1.20 . I cannot connect to DB with this user without ssl. I could not find ssl option under odbc driver. Is there a way? Thanks! submitted by /u/twocentsrworth [visit reddit] [comments ..read more

submitted by /u/greenman [visit reddit] [comments ..read more

Do I have to add index manually? Or MariaDB adds an Index for me? Create table posts ... CONSTRAINT FOREIGN KEY (user_id) REFERENCES users (id) ON UPDATE CASCADE Post table has user_id. Will it be index automatically? Do I have to add an index manually now? How do I check if there is an index already? submitted by /u/Mahesh-Thought [visit reddit] [comments ..read more

putting mariadb on a server? submitted by /u/savant78 [visit reddit] [comments ..read more

I was thinking to design tables for quiz. Quiz Table ‘’’id primary key title/name varchar other infos (createdon, user id, status…)’’’ Questions table id question fk_quiz_id Choices id choice fk_question_id This is by basic idea. Alternatively i can create something like this. Quiz id title questions json (array of questions with choices) I feel the json variation is better than relational.. What is the advantage and disadvantage with JSON? This is the first time i am thinking to use JSON. submitted by /u/Naive-Staff6186 [visit reddit] [comments ..read more

Hello MariaDB Community, We are currently using DBeaver to import a CSV? We need that CSV import, but we want to automate it; hence we need to actually write the SQL for it. How can we replicate that import we do with DBeaver in a SQL Statement? https://preview.redd.it/16hsjgravttc1.png?width=619&format=png&auto=webp&s=58fb73b441d3877f0034f0eacc2d068438c9601e ​ submitted by /u/Mr_LA [visit reddit] [comments ..read more

Hello from the MariaDB team! We are specifically part of the teams that develop the roadmap for MariaDB database products, and provide support and services for our customers. Join our head of product Joe Cotellese and head of technical operations (i.e. our support and services organizations) Ben Stillman in this upcoming AMA. Our focus will be on answering questions we know best – features and functionality around MariaDB Server and other MariaDB products (MaxScale, ColumnStore, etc), best practices for deploying and operating MariaDB, and questions about us or our product and technical opera ..read more