Durchsuchen nach
Schlagwort: database

After upgrading to Fedora 42, problems with the MySQL database due to downgrading

After upgrading to Fedora 42, problems with the MySQL database due to downgrading

First of all, it took me three hours of troubleshooting to solve the problem. I took a day off because it requires the utmost concentration. It’s not something you can do on the side. What is troubleshooting? Troubleshooting involves fault finding and fault correction and is a systematic approach to problem solving that is often used to find and eliminate problems in complex machines, electronics, computers and software systems. The first step in most troubleshooting methods is to gather information…

Weiterlesen Weiterlesen

Python MySQL create a database and a table

Python MySQL create a database and a table

This is a Python script in order to create first the database and then a table with different values in one step. It is useful, then you don’t need to do it in two steps. What is the requirement for the script Installation of Python Windows and Mac For this script, you need to install Python if you are on Windows and Mac. Go to the official web page of Python.org and download your package and installed like another program….

Weiterlesen Weiterlesen

DBeaver for my MySQL databases

DBeaver for my MySQL databases

I used in the past the MySQL Workbench as a stand-alone program in my Fedora desktop. But after a while the distribution did not support the Workbench directly. It could only install it via snap. But in snap you have the problem, that this service produces a lot of log entries into a file in /var/log/messages* so you had to delete this big files after a while. The other solution was to use the MySQL workbench as a plugin in…

Weiterlesen Weiterlesen

MongoDB in Fedora Linux – how is the configuration of the server

MongoDB in Fedora Linux – how is the configuration of the server

Mongoshell The MongoShell is an interactive command window for the MongoDB database. You can use it for the CRUD operations. The MongoShell comes with the installation of MongoDB. After test, you type in the commands. What is CRUD? Create, Read, Update, Delete The command for the MongoShell mongosh It is possible that you see this message, but you can ignore it: and type the command: db.serverCmdLineOpts() The output is in the JSON (JavaScript Object Notation) Format. test> db.serverCmdLineOpts(){argv: [ ‚/usr/bin/mongod‘,…

Weiterlesen Weiterlesen

3 best methods to find out the installed version of MongoDB on Linux

3 best methods to find out the installed version of MongoDB on Linux

What is MongoDB? MongoDB is a document-oriented NoSQL database that stores data in flexible, JSON-like documents, allowing for easy storage and retrieval of structured, semi-structured, and unstructured data. Unlike traditional relational databases that use tables and rows, MongoDB uses collections and documents, making it more adaptable to changing data structures. It was designed to handle large volumes of data and is known for its scalability, flexibility, and ease of use. MongoDB is open-source and has a wide range of deployment options, including cloud-based services like…

Weiterlesen Weiterlesen