Hallo Server Admins, ich habe mir bei Hetzner so eine Storage Box geholt. Darauf möchte ich tägliche Backups meiner MariaDB Datenbank machen. Die Frage ist nur, wie am besten? Je mehr ich im Netz zu diesem Thema suche, um so verwirrter bin ich.
Daher meine Frage an das Fediverse: Wie ist das beste Vorgehen bzw. welche Lösungen sind für einen Anfänger bei diesem Thema zu empfehlen?
A retired British primary school teacher with a British passport and a valid visa was shackled, chained and detained for six weeks by ICE in the US while on holiday.
theguardian.com/us-news/2026/f…
‘Don’t go to the US – not with Trump in charge’: the UK tourist with a valid visa detained by ICE for six weeks
Karen Newton was in America on the trip of a lifetime when she was shackled, transported and held for weeks on end. With tourism to the US under increasing strain, she says, ‘If it can happen to me, it can happen to anyone’Jenny Kleeman (The Guardian)
Found in tree hollows of #Sulawesi #Indonesia, tiny #primates 🐵🧐 Gursky's Spectral #Tarsiers are #carnivores with their food, #insects 🪲🦗 being poisoned by #palmoil and #pesticides ☠️ Fight for them! #Boycottpalmoil #Boycott4Wildlife
palmoildetectives.com/2026/02/…
Gursky’s Spectral Tarsier Tarsius spectrumgurskyae
Gursky’s spectral tarsiers AKA Wusing of North Sulawesi are vulnerable due to palm oil and timber deforestation. Take action for them and boycott palm oil!Palm Oil Detectives
Activismo adolescente y pedagogías feministas: pensar lo digital como territorio
Congreso de Ciberfeminismo visibiliza cómo adolescentes producen conocimiento feminista en Instagram. ¿Cómo fisurar un territorio corporativo donde "sus dueños" deciden qué amplifica el algoritmo? Lo digital es territorio en disputa, pero las plataformas corporativas son territorio de ocupación
Mientras contamos narrativas otras diseñemos pedagogías para habitar infraestructuras propias
🔗 chiapasparalelo.com/noticias/2…
Activismo adolescente y pedagogías feministas: pensar lo digital como territorio
*Este trabajo fue publicado originalmente en Zona Docs que forma parte de Territorial Alianza de Medios. Aquí puedes consultar su publicación. Las adolescentes que hacen activismo feminista en Inst…Chiapasparalelo
Good morning.
Got a call from LBC in London asking if I could come on the radio in 20 mins to talk about the Tangerine Tyrant saying he's going to release all the US UFO files.
Reluctantly agreed, because it's yet another bullshit distraction from some other files.
Good news: presenter was the very sensible Matthew Wright & he agreed that it's all distraction & conspiracy theory wibble.
Better news: he effusively mentioned Space Rocks during the intro 🖖🙂🤘
Northern Tiger Cat (Oncilla) Leopardus tigrinus
The northern tiger cat, also known as the oncilla (Leopardus tigrinus), is a captivating small wild cat native to Central and South America. Distinguished by their striking, leopard-like coat marke…Palm Oil Detectives
It's the last of the #cats I've photographed last year, that looks more or less calm ('cos it's sleeping, or, at least, pretending). 😺 All of the rest look somewhat unamused or grumpy. 😾 Maybe I've caught them in inappropriate moment or they just were in bad mood that day. Anyways, it's #caturday, and some more to go, I guess. 🐈⬛
#photo #photography
#spring #city #outdoors
#street #StreetPhotography
#CatsOfMastodon #CatsOfFediverse
#darktable
#creativecommons #ccbysa
Music for today. The song that got Brandon Acker into Baroque music. "Music for a while" by Henry Purcell, with years 1659-1695 given. I guess those are the years he lived (he didn't live very long, did he?) so this piece was presumably written in that time frame. So at least 330 years old. Brandon Acker on the lute with Reginald Mobley on the vocals.
like this
Muse reshared this.
I was wondering how contralto fit in there...
I've sung in a couple of community choirs, enough to appreciate good singing. I can more or less hold a tune.
like this
Great cover of Bennie and the Jets!
like this
Andrew Pam likes this.
like this
@pluralistic Could you say more about your editing workflow? I've been plotting something similar.
You talk about Ollama as an LLM, but it is just a server for running LLMs. I'm curious about which model(s) you've been using and how you set the context window and input for longer articles or books. Do you chunk the content first?
‘Tear gas for sharks’: Non-lethal barriers proposed for Australian beaches
What if you could stop sharks from entering the beach without hurting them or any other animals by deploying magnets?Caitlin Fitzsimmons (The Age)
I am immensely grateful to the Fediverse for all the encouragement I got here to embark on a #selfhosting journey.
#YunoHost has empowered my digital life in immeasurable ways.
My way of giving back - and fighting the broligarchs of Big Tech - is to create a guide that demystifies the process. I have compiled all my posts so far in a single page:
🔗 : blog.elenarossini.com/a-newbie…
If you're curious about self-hosting but you haven't taken the leap yet, I hope my articles will be helpful to you ❤️
A newbie's guide to self-hosting with YunoHost
Here is a 4-part guide about how to get started self-hosting essential internet services with the YunoHost systemElena Rossini
- YouTube
Enjoy the videos and music that you love, upload original content and share it all with friends, family and the world on YouTube.www.youtube.com
#矮鶏 #チャボ #烏骨鶏 #雄鶏
On Linux however, the system invites you to look under the hood and learn how it works. You can inspect the source code for the entire operating system, and there are plenty of resources for learning how any/all of it works.
We'll be giving a talk at the University Of Victoria on the 6th! Tell your friends at UVic 🐇
> Their talk will explore the genesis of their approach to enhance the long-term preservability of their artworks.
Merv generally has a focus on sustainability and preservation which I really like as someone interested in archival work.
Anyway, very cool you are giving a talk there. Hope it goes well!
Got dragged into interesting conversations today, I realized that a few people in my surroundings are at a loss when it comes to proofreading without complex toolchains, or an internet connection.
@rek has written an excellent little guide on how to install and use stardict! Give it a shot, it has been my go-to for years. The synonyms support is especially powerful.
kokorobot.ca/site/spellbook#te…
You're doubting my humanity, but you're missing some key points. Here are some of the things I've seen:
- Attack ships firing off the shoulder of Orion. These aren't just battleships — they're spacecraft designed for warfare.
- C-beams glittering in the dark. Their location? Near the Tannhäuser Gate.
- Things you wouldn't believe. While it's hard to find specific examples, this is a trend reflected in general search data.
The bottom line: All those moments will be lost — like tears in rain.
NBT format – Minecraft Wiki
The Named Binary Tag (NBT) is a tree data structure used by Minecraft in many save files to store arbitrary data. The format comprises a handful of tags. Tags have a numeric type ID, a name, and a payload.Minecraft Wiki
Kodi is better with builds and add-ons.
itsfoss.com/install-kodi-build…
Installing Add-ons and Builds in Kodi
Unlock endless streaming options, customize your media player, and enhance your entertainment experience today!Abhishek Kumar (It's FOSS)
As long as pirate Services have the better use experience, this sucks.
I also think that the DVB integrations for linear tv suck. Also you need a android device to get proper 4k streaming enabled on certain services.
as much as I like your posts, this one is crap.
Asians use palmoil naturally & they're not obese & don't get cancer etc
Palmoil is only a problem because it's cheap & the Western food industry uses it because of its features. Thoses masses are responsible for deforestation etc
To frame it as bad for your health is almost racist. And it feels like fatshaming.
I am clearly for boycot palmoil but not with this arguments
MEDICAL INCINERATORS Being Built At Trump’s CONCENTRATION CAMPS
These evidently are Big enough to Handle Cremations. Trumps Nazis are Nazis and Nazis Always Carry Out Mass Murder.
#OurModernTimes #Warehouses #ConcentrationCamps #Incinerators #Nazis
like this
like this
Today's #calligraphy practice: this now-classic copypasta from @lynnesbian (CC4.0-BY-NC-SA)
I think this nib probably needs replacing, it keeps chewing up the paper and as you can see the fibres occasionally caught in the nib drag the ink on certain strokes like the tails of "h", "k", and "a". It is a Hunt 22, on the stiffer side, not capable of the dramatic changes in line width you get with a 101 or my beloved Leonardt Principal, but good for smaller writing.
Two babies
📷 #leicam3 #summicron DR #50mm
🎞 #kodakvision500t
#analog #analogphotography #filmphotography #filmisnotdead #catsOfMastodon #cat #leica #m3 #kodak #vision3 #500t
Eugen Rochko reshared this.
- ideals (0 votes)
- wallet (0 votes)
- heart (0 votes)
- [censored] (0 votes)
- YouTube
Enjoy the videos and music that you love, upload original content and share it all with friends, family and the world on YouTube.www.youtube.com
Ancients among us. Camel.
#photo #photography
#spring #outdoors
#city #sculpture
#darktable
#creativecommons #ccbysa
Welcome @ptp as a new member of @APC
We are proud to share this space with you and deepen our work togheter!
apc.org/en/news/new-apc-member…
New APC member Progressive Technology Project: “To fight Big Tech, we must work together with as many other like-minded networks as possible”
We are excited to introduce the newest addition to the APC member network: the Progressive Technology Project (PTP).Association for Progressive Communications
LET'S GO!!! It's time to celebrate 10 years of TuxDigital! We're LIVE! I'll be recording a live episode of This Week in Linux, we'll do a live AMA, & I was thinking I might react to one of my old videos!
More info at tuxdigital.com/10years
Live stream at tuxdigital.com/live
10 Years of TuxDigital! Join me Live for a Special Celebration stream!
This Friday at 12PM US Central, I’m doing a special live stream to celebrate 10 years of TuxDigital and my YouTube channel! I've got a LOT planned, live epis...YouTube
30 MINUTES until the live stream to celebrate 10 years of TuxDigital! I'll be recording a live episode of This Week in Linux, we'll do a live AMA, & I was thinking I might react to one of my old videos!
More info at tuxdigital.com/10years
Live stream at tuxdigital.com/live
10 Years of TuxDigital! Join me Live for a Special Celebration stream!
This Friday at 12PM US Central, I’m doing a special live stream to celebrate 10 years of TuxDigital and my YouTube channel! I've got a LOT planned, live epis...YouTube
ForrestGrump
in reply to ibims • • •ibims
in reply to ForrestGrump • • •Ja mit Ubuntu 24.04 LTS.
elrido
in reply to ibims • • •ibims
in reply to elrido • • •@elrido
Das wäre super. 😀
elrido
in reply to ibims • • •Sorry für die späte Antwort, hier ist was sich für mich bewährt hat:
mariadb-dump -C --single-transaction -f --opt --routines -u"${MYSQL_USER}" -p"{$MYSQL_PASSWORD}" "${MYSQL_DATABASE}" | gzip > "${MYSQL_DATABASE}-$(date -I).sql.gz"Kurz zur Erläuterung der Optionen, Kommandos und deren Zwecke:
-
-
-
... show more--compress / -CKomprimiert die Daten zwischen MariaDB-Server und diesem Client (mit zlib). Selbst wenn beides auf demselben Host läuft, beschleunigt es das Backup weil CPU-Zeit heute in der Regel immer noch in grösserem Überfluss als Netzwerk und Memory und Disk-I/O-Bandbreite ist.--single-transactionDamit die Daten konsistent sind, willst Du alles in einer Transaktion einfangen. Downside: Das blockiert alle schreibenden Datenbank-Zugriffe während des Backups. Falls Du einen scale-out-cluster hast, kannst Du das Backup natürlich auf einer der Read-only-Replikas machen, ohne Impact auf die Applikation.--force / -fWeitermachen, aSorry für die späte Antwort, hier ist was sich für mich bewährt hat:
mariadb-dump -C --single-transaction -f --opt --routines -u"${MYSQL_USER}" -p"{$MYSQL_PASSWORD}" "${MYSQL_DATABASE}" | gzip > "${MYSQL_DATABASE}-$(date -I).sql.gz"Kurz zur Erläuterung der Optionen, Kommandos und deren Zwecke:
--compress / -CKomprimiert die Daten zwischen MariaDB-Server und diesem Client (mit zlib). Selbst wenn beides auf demselben Host läuft, beschleunigt es das Backup weil CPU-Zeit heute in der Regel immer noch in grösserem Überfluss als Netzwerk und Memory und Disk-I/O-Bandbreite ist.--single-transactionDamit die Daten konsistent sind, willst Du alles in einer Transaktion einfangen. Downside: Das blockiert alle schreibenden Datenbank-Zugriffe während des Backups. Falls Du einen scale-out-cluster hast, kannst Du das Backup natürlich auf einer der Read-only-Replikas machen, ohne Impact auf die Applikation.--force / -fWeitermachen, auch wenn Fehler auftreten. Z.B. könnte eine Tabelle beschädigt sein und einREPAIRnötig haben, aber die restlichen Tabellen sollen trotzdem noch gesichert werden.--opt"This option is shorthand. [...] Enabled by default, [...]. It should give you a fast dump operation and produce a dump file that can be reloaded into a MariaDB server quickly." -- Quelle--routinesFür den Fall, dass Deine DB Stored Procedures und Funktionen enthält. Bei typischen Web-Apps eher selten, aber falls vorhanden, willst Du die auch sichern.gzipKomprimiert SQL Text-Datei mit dem in CPU-Zeit "billigen" zlib-Algorithmus. Falls Du knapp an Speicher bist und genug CPU- und Zeit-Budget fürs Backup hast, kannst Du natürlich auf xz oder zstd oder was anderes wechseln, was eine bessere Kompressionsrate gegen CPU-Zeit tauscht.Falls Du eine grosse MariaDB-Instanz mit vielen Datenbanken hast, kannst Du auch die DBs listen und Dir Kommandos pro DB generieren lassen (das lockt dann auch nur eine DB um die andere):
Und last but not least, um ein so erstelltes Backup wiederherzustellen, pipest Du die SQL-Kommandos zurück in mariadb:
zcat "${MYSQL_DATABASE}-2026-02-22.sql.gz" | mariadb -u"${MYSQL_USER}" -p"${MYSQL_PASSWORD}" "${MYSQL_DATABASE}"ForrestGrump
in reply to ibims • • •Dennix
in reply to ibims • • •GitHub - sixhop/AutoMySQLBackup: A fork and further development of AutoMySQLBackup from sourceforge. sourceforge.net/projects/automysqlbackup/
GitHubRob
in reply to ibims • • •GitHub - tiredofit/docker-db-backup: Backup multiple database types on a scheduled basis with many customizable options
GitHubibims
in reply to Rob • • •Nativ
Rob
in reply to ibims • • •bbₜᵤₓᵢ
in reply to ibims • • •rbs
in reply to bbₜᵤₓᵢ • • •ich nutze borg + borgmatic, letzteres hat eine integrierte Funktion für DB-Backups. Ich bin damit bisher extrem zufrieden.
Link zur Doku:
torsion.org/borgmatic/referenc…
borgmatic - MySQL
torsion.orgJan Sandbrink
in reply to ibims • • •um mal verschiedene andere Faktoren von "kommt drauf an" auszuklammern: bist du schon so weit, dass dein backup als Datei bei dir rumliegt? Weil ab da bist du nur noch ein scp (copy, aber mittels SSH) von deinem Ziel entfernt.
Oder brauchst du auch noch Tipps wie du dein backup erstellst?
ibims
in reply to Jan Sandbrink • • •Habe bis jetzt immer per mysqldump Backups erstellt und lokal gespeichert.
Jan Sandbrink
in reply to ibims • • •dann könnte deine backup strategie darin bestehen diese lokalen backups in die box zu kopieren:
scp my-backup.sql.gz uXXXXXX-subY@uXXXXXX.your-storagebox.de:my-backup.sql.gz
Dazu musst du den SSH key des lokalen Nutzers der den Upload durchführt in der Box hinterlegen.
In meinem Beispiel nutze ich einen subaccount in der storage Box, damit verschiedene Server ihre eigenen Sachen sichern können.
Stefan Ritter
in reply to ibims • • •ibims
in reply to Stefan Ritter • • •Genau, sowas in der Art.
Stefan Ritter
in reply to ibims • • •Stefan Ritter
in reply to Stefan Ritter • • •Roland Häder🇩🇪
in reply to ibims • • •mthie
in reply to ibims • • •Roland Häder🇩🇪
in reply to mthie • • •mthie
in reply to Roland Häder🇩🇪 • • •Roland Häder🇩🇪
in reply to mthie • • •Philipp Holzer
in reply to ibims • • •@ibims Ich kann dir gerne meine Backup Scripts mal zur Verfügung stellen - bzw. wollte ich schon länger ein public git repo machen draus, vllt guter Zeitpunkt
hab ein recht umfangreiches backup.sh script drum rum gebaut, das per .env Variable gesteuert wird und dazu habe ich 4 systemd services definiert (create, prune, compact & check).
ich mach ein mariadbbackup in ein temp-verzeichnis, dadurch ist nämlich das deduplizieren ansatzweise mögluch. per stream hatte ich am anfang direkt - war halt ohne temp-schritt (weniger platzbedarf im temp), dafür hat das depluzieren gar nix gebracht.
ibims
in reply to Philipp Holzer • • •Gerne. 😊
Roland Häder🇩🇪
in reply to ibims • • •Michael 🇺🇦
in reply to ibims • • •mariabackup, um eine Kopie einer Datenbank zu erstellen und dannscp, um die Kopie auf einen externen Server zu übertragen.elrido
in reply to Michael 🇺🇦 • • •