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

Hello, I am more or less following redmine documention for installing and running mariaDB and redmine but seem to have gotten stuck at one of the steps. I need to input command "RAILS_ENV=production bundle exec rake db:migrate" but when I do I get error "Unknown system variable 'transaction_isolation'". When I search for this error I get a solution to execute select @@transaction_isolation; select @@version; in the mariaDB server command line. When I do this though I just get next line ">" and nothing happens. Any thoughts on how to proceed from here? Ver: MariaDB 10.6.16 submitted by /u ..read more

In case you're interested in attending the live Q&A on Apr 17th at 12 PM CST, sign up here. https://go.mariadb.com/GLBL-WBN-AMA-webinar1-2024-04-17_Registration-LP.html ​ submitted by /u/Enrique-M [visit reddit] [comments ..read more