"a brief guide to rsync"
https://www.youtube.com/watch?v=eifQI5uD6VQ #linux #unix #rsync
#Rsync
RSYNC (GRSYNC) - logiciel de synchronisation
Ich wundere mich, dass diverse Backup-Scripte plötzlich scheitern (“Too many open files”) – das erklärt’s wohl: https://www.mactechnews.de/news/article/macOS-15-4-Apple-ersetzt-ohne-Warnung-rsync-und-sorgt-fuer-Probleme-187088.html #macos #rsync #openrsync
Moved all my off-site files from S3 to rsync.net. Hoping for better user experience due to being able to SFTP and run commands like find or doing proper renames.
Anruf von Bekannter: Das vor einiger Zeit für sie eingerichtete Backupsystem mittels rsync vom Mac aufs NAS funktioniert nicht, Fehlermeldung sinngemäß "hostname not found". NAS ist über alle möglichen Wege erreichbar, nur #rsync will nicht mehr. Nach langer Suche stellt sich heraus, dass #apple beim Update auf die 15.4 rsync durch openrsync ausgetauscht hat und deshalb eine andere Syntax notwendig ist. Alter Falter... sowas kann ich nicht gut leiden.
A faster way to copy SQLite databases between computers – alexwlchan
LinkA faster way to copy SQLite databases between computers
https://example.com/faster-sqlite-copy
📌 Summary:
本文介紹了一種更快速且穩定地在不同電腦間傳輸 SQLite 資料庫的方法。作者面臨傳統使用 rsync 直接複製 SQLite 資料庫的瓶頸，特別是在資料庫規模增大且含有多個索引時，複製時間顯著增加且容易出錯。解決方案是利用 SQLite 的 .dump 指令將資料庫導出為包含建表及插入指令的純文字檔，該檔案大小往往比原始資料庫小許多，主要因為索引只以指令形式存在，不重複儲存數據。再將這個文字檔壓縮成 gzip 檔案，透過 ssh 傳輸到本機後解壓，再依序執行文字檔內容重建資料庫。這樣不僅減少了傳輸檔案大小，也避免了傳輸過程中資料庫被異動導致損壞的問題，進而提升傳輸速度與穩定性。最後作者分享實際例子，一個 3.4GB 的資料庫壓縮後文字檔僅約 240MB，縮小約 14 倍，顯著節省傳輸時間及資源。
🎯 Key Points:
→ ★ 問題描述：隨著 SQLite 資料庫及索引規模增大，使用 rsync 複製資料庫耗時且容易出錯。
→ ★ 主要瓶頸：索引會額外複製重複資料，導致檔案體積膨脹。
→ ★ 解決方案：利用 sqlite3 的 .dump 指令將資料庫轉成 SQL 指令的純文字檔，內容包含建表、插入資料以及索引建立語法。
→ ★ 優點：純文字檔大小常小於原始資料庫，gzip 壓縮後更為顯著，減少資料重複複製。
→ ★ 實務流程：① 在遠端伺服器透過 ssh 指令產生壓縮的純文字檔，② 使用 rsync 傳輸該檔案到本地，③ 解壓縮並利用 sqlite3 將 SQL 指令匯入重建資料庫，④ 清理暫存文字檔。
→ ★ 穩定性提升：先產生純文字轉存版本，避免在傳輸過程中資料庫被更新造成不一致導致打開錯誤。
→ ★ 範例數據：3.4GB 的 SQLite 資料庫，轉 dump 後文字檔約 1.3GB，用 gzip 壓縮後約 240MB，縮減近 14 倍。
→ ★ 實務價值：大量或多索引的 SQLite 資料庫能透過此方法更有效率且安全地傳輸與備份。
🔖 Keywords:
#SQLite #資料庫備份 #資料庫傳輸 #gzip壓縮 #rsync
🚀 Hey tech wizards, did you know copying a database just got a whole minute faster? 😂 Apparently, #rsync has been discovered in 2025! 🎉 Prepare to be blown away by cutting-edge revelations from the future! 🚀📂
https://alexwlchan.net/2025/copying-sqlite-databases/ #technews #futuretech #databaseinnovation #speedupdates #hackernews #HackerNews #ngated
Curious if it is truly as simple as running #rsync across the VPSs both running :debian: Debian 11 like and resting up the DNS name server IPs like this guide claims
https://www.man42.net/blog/2017/07/how-to-migrate-a-debian-server/
https://www.man42.net/blog/2017/07/how-to-migrate-a-debian-server/
@thoralf
Ich verstehe eh nicht, warum #NextCloud so beliebt ist. Vielleicht weil es viele Features hat und daher in der Theorie auch sehr viele use Cases abbilden kann. In der Praxis läuft es halt wie von dir beschrieben.
Für File Sync gibt es im #Linux/Open-Source-Bereich viele gute Lösungen. Die Frage ist immer wer oder was auf der anderen Seite ist. #Syncthing #Seafile #Filen oder #Unison #rsync
Mit Web-Anwendungen habe ich weniger Erfahrung, aber Webmailer gibt es auch bessere.
Fliegender Synchronisationswechsel: #Apple :apple_inc: ersetzt #rsync durch #openrsync | Mac & i https://www.heise.de/news/Fliegender-Synchronisationswechsel-Apple-ersetzt-rsync-durch-openrsync-10350428.html #OpenSource #macOS154
I didn’t know about openrsync until recently — been using rsync for years and somehow missed it!
openrsync is a lightweight rsync replacement developed by the OpenBSD team.
It focuses on security, simplicity, and a small footprint.
While not yet feature-complete compared to GNU rsync, it supports common
use cases like recursive copying, preserving permissions, and syncing over SSH.
Originally introduced in OpenBSD 6.5 (May 2019)
Authored by Kristaps Dzonsons
🔗 https://www.openrsync.org/manual.html
Thinking about writing a SlackBuild for it — I’ll give it a proper test first. 🙂
#openbsd #openrsync #slackbuild #rsync
openrsync is a lightweight rsync replacement developed by the OpenBSD team.
It focuses on security, simplicity, and a small footprint.
While not yet feature-complete compared to GNU rsync, it supports common
use cases like recursive copying, preserving permissions, and syncing over SSH.
Originally introduced in OpenBSD 6.5 (May 2019)
Authored by Kristaps Dzonsons
🔗 https://www.openrsync.org/manual.html
Thinking about writing a SlackBuild for it — I’ll give it a proper test first. 🙂
#openbsd #openrsync #slackbuild #rsync
One thing not mentioned is that #OpenRsync's origin is the #OpenBSD project (at least as far as I am aware! Correct me if I am wrong :-) )!
https://derflounder.wordpress.com/2025/04/06/rsync-replaced-with-openrsync-on-macos-sequoia/
Thanks to a helpful suggestion from ryandesign, I modified the Portfile to stop passing the --prefix styled parameter using your suggestion for the oconfigure style and submitted a Pull Request to add openrsync to MacPorts here:
https://github.com/macports/macports-ports/pull/28096
GitHub Continuous Integration checks passed OK!
Here's hoping it gets merged without issues (I included some of the warnings from running %port test and maybe some other MacPorts contributors will have some helpful suggestions for clearing those up too).
Regardless, thank you for your efforts! I'm grateful to be able to downstream it in my own limited capacities. I realize, not as helpful as it might be if Apple were more collaborative, but who knows wtfh Tim "Apple" is up to besides removing headphone jacks and selling off stocks and racing devices out of India before tariffs impact their bottom line, or whatever it is that they do in Cupertino.
#OpenRSYNC #OpenBSD #MacPorts #rsync
CC: @ParadeGrotesque@mastodon.sdf.org @pertho@bsd.cafe @dexter@bsd.network
https://github.com/macports/macports-ports/pull/28096
GitHub Continuous Integration checks passed OK!
Here's hoping it gets merged without issues (I included some of the warnings from running %port test and maybe some other MacPorts contributors will have some helpful suggestions for clearing those up too).
Regardless, thank you for your efforts! I'm grateful to be able to downstream it in my own limited capacities. I realize, not as helpful as it might be if Apple were more collaborative, but who knows wtfh Tim "Apple" is up to besides removing headphone jacks and selling off stocks and racing devices out of India before tariffs impact their bottom line, or whatever it is that they do in Cupertino.
#OpenRSYNC #OpenBSD #MacPorts #rsync
CC: @ParadeGrotesque@mastodon.sdf.org @pertho@bsd.cafe @dexter@bsd.network
Preview Backup Level 2, mal schauen watt datt wird.
macOS 15.4 中 rsync 被換成 OpenRsync
主要是看到「Rsync replaced with openrsync on macOS Sequoia (derflounder.wordpress.com)」這邊的消息，macOS 15.4 的更新中，rsync 被換成 OpenRsync 了：「rsync replaced with openrsync on macOS Sequoia」。 macOS 的 rsync 一直維持 2007 年的 2.x 版，主要的原因是後來變成 GPLv3 了，而 OpenRsync 是 OpenBSD 團體弄出來的版本，使用 BSD licenses。 OpenRsync 畢竟是重寫一套出來，可以預期會有相容性問題，再加上 OpenRsync 本來就沒打算做到完全相容，但基本與常見的功能都有實作出來，算是堪…
Client Info
Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst