Mydumper Alternatives

mydumper reviews and mentions

• Ask HN: Any one still using MySQL?
  1 project | news.ycombinator.com | 8 May 2024

  Yes, but MariaDB, mostly DIY on localhost (various test & live VMs I manage).

  Most painful? Replication with automatic failover could be easier to setup. Considering switching to MySQL 8.x for the new-ish innodb cluster tools (mysqlsh, mysql-router).

  Why not Postgres? Familiarity, mostly using it for Drupal & Wordpress sites where MySQL is king. Besides the occasional poorly-designed query that eats memory and causes timeouts, MySQL rarely needs my attention.

  Side note: I'm excited for https://github.com/mydumper/mydumper. Multi-threaded logical backups, 2 to 5 times faster than mysqldump. It's not super stable yet, so we haven't been relying on it for long term backups, but doing a "mydumper to grab a schema on live, rsync down to laptop, myloader to import" it's been a big time saver.

• Restore or Migrate your MySQL Database to Railway
  2 projects | dev.to | 3 Nov 2023

  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.

• Has anyone ever restored a 15GB db from mysqldump?
  1 project | /r/sysadmin | 9 May 2023

  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).

• Recommend me an Azure-native solution for archival and encryption
  1 project | /r/AZURE | 1 Apr 2023

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

• mysqldump for innodb + myisam mixed db
  1 project | /r/mysql | 15 Mar 2023

  Either xtrabackup, or mydumper.

• Is --single-transaction enough to protect mysqldump while backing up a replication replica?
  1 project | /r/mysql | 22 Feb 2023

  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.

• MariaBackup Restore to Second 'test' database
  1 project | /r/mariadb | 27 Jan 2023

  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.

• Is replication between v5.1 and v8 possible?
  1 project | /r/mysql | 25 Nov 2022

  Take a snapshot backup of the 5.1 server with mydumper.

• How to transfer data across MySQL 5.7 servers, from Windows to Ubuntu?
  1 project | /r/sysadmin | 6 Nov 2022

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

• Fastest method of making a copy of a database on another server?
  1 project | /r/mariadb | 18 Aug 2022

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

• A note from our sponsor - SaaSHub
  www.saashub.com | 25 Jan 2025

  SaaSHub helps you find the best software and product alternatives Learn more →