mydumper VS rsync

You can create a MySQL backup for Railway.app using the MyDumper tool or by using a backup service like SimpleBackups. Both methods involve generating a dump file that can be used for restoration.

Maybe check mydumper which uses a multi-threaded multi-file approach so that backups are faster, but more important, restores are faster. Plus it makes it way easier to do a partial recovery (for instance, a specific table).

It looks like MyDumper added support to invoke PGP, etc. https://github.com/mydumper/mydumper/issues/101

Either xtrabackup, or mydumper.

Use mydumper. It has lightweight locking that can produce consistent backups without stopping replication. It also has multi-threaded sharding so it can backup much faster.

Agree with you, just let me suggest mydumper as a parallel and compressed version of mysqldump, much faster way to export and import tables- unless your tables are tiny.

Take a snapshot backup of the 5.1 server with mydumper.

Either way, use mydumper. It is much faster than basic mysqldump.

Check out mydumper it's multithreaded and way faster than mysqldump.

Better than basic mysqldump is mydumper. It has a bunch of nice features like multi-threaded parallel dumping. It can cut the dump/restore time by a huge amount.

rsync can be used to synchronize a local disk to the pCloud drive p. Works similarly as the Sync option of the pCloud Drive app. May be useful if one prefers a bulk upload once a day over a continuous synchronization.

Tools that can be used to handle this include Rsync, Duplicati, Cohesity

To overcome this issue, you can use rsync, a powerful command-line tool for synchronizing files and directories, along with a bash script that excludes the node_modules folder and also filter out anything in a .gitignore file that you specify. In this article, I'll guide you through the process of setting up and using this bash script to sync your Node.js project while ignoring the node_modules folder.

On OL9 I installed rsync using https://github.com/WayneD/rsync/blob/master/INSTALL.md and installing dependencies using the For Fedora 33 commands where possible except xxhash which wasn't found, so I used https://oraclelinux.pkgs.org/9/ol9-codeready-builder-aarch64/xxhash-devel-0.8.1-3.el9.aarch64.rpm.html

rsync will probably work better for this use case

I would prefer to use a revision control system, like git if keeping multiple versions of documents is important. Otherwise, if you don't find anything else to your liking, you could write your own scripts based on rsync with the clone-dest, detect-renamed, and detect-renamed-lax patches.

Give rsync a try, it should handle UTF filenames just fine.

While researching this issue I stumbled upon this thread where someone found out that a rsync 3.2.3 / glibc bug (github issue) leads to the error Operation not supported (95).\ my Proxmox instance is also using rsync 3.2.3: root@proxmox:~# rsync -V rsync version 3.2.3 protocol version 31 In this thread I found it's recommended to upgrade to another rsync version, but I'm not really sure how.\ \ Any thoughts on this?