Installation Dependencies

dnf install -y cmake gcc gcc-c++ git make

Downloading and Installing MyDumper

wget https://github.com/mydumper/mydumper/releases/download/v0.14.1-1/mydumper-0.14.1-1.el9.x86_64.rpm
dnf install mydumper-0.14.1-1.el9.x86_64.rpm -y

MyDumper Configuration Options

mydumper --help

Displays comprehensive options for connection settings, filtering, locking mechanisms, execution parameters, checksum operations, object handling, statement formatting, and addditional featuers.

Myloader Configuration Options

myloader --help

Shows available parameters for connection configuration, filtering, execution modes, thread management, and statement processing during data restoration.

Practical MyDumper Usage Examples

mydumper -u admin -p securepass -o /backup/full/
mydumper -u admin -p securepass -G -R -E -B sampledb -o /backup/sampledb/
mydumper -u admin -p securepass --regex '^(?!(mysql|sys))' -o /backup/userdbs/
mydumper -u admin -p securepass -B sampledb -T users,products -o /backup/tables/
mydumper -u admin -p securepass -d -B sampledb -o /backup/schema_only/
mydumper -u admin -p securepass -m -B sampledb -o /backup/data_only/
mydumper -u admin -p securepass -B sampledb -T transactions -c -o /backup/compressed/

Myloader Restoration Examples

myloader -u admin -p securepass -o -d /backup/full/
myloader -u admin -p securepass -s sampledb -o -d /backup/sampledb/
myloader -u admin -p securepass -B restored_db -s sampledb -o -d /backup/sampledb/
myloader -u admin -p securepass -e -o -d /backup/sampledb/

For individual table restoration, use MySQL command line:

source sampledb.users-schema.sql
source sampledb.users.sql