Durchsuchen nach
Kategorie: Datenbanken

Datenbanken wie MySQL und MongoDB kommen hier vor.

Nach Upgrade nach Fedora 42 Probleme mit der Datenbank MySQL, wegen Downgrading

Nach Upgrade nach Fedora 42 Probleme mit der Datenbank MySQL, wegen Downgrading

Vorneweg, ich habe drei Stunden Troubleshooting gebraucht, also das Lösen des Problems liegen hinter mir. Ich habe mir einen Tag Pause gegönnt, denn es ist höchste Konzentration vonnöten. So etwas macht man nicht nebenbei. Was ist Troubleshooting? Troubleshooting umfasst die Fehlersuche und die Fehlerbehebung und ist ein systematischer Ansatz zur Problemlösung, der häufig verwendet wird, um Probleme in komplexen Maschinen, Elektronik, Computern und Softwaresystemen zu finden und zu eliminieren. Der erste Schritt bei den meisten Fehlerbehebungsmethoden ist das Sammeln von…

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

Linux (Fedora 41) Bash Script to do a backup for MongoDB

Linux (Fedora 41) Bash Script to do a backup for MongoDB

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

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