Durchsuchen nach
Kategorie: Datenbanken

Datenbanken wie MySQL und MongoDB kommen hier vor.

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

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