MYLOADER(1)

📦
version 0.10.1 · 6 versions
, in ubuntu resolute, ubuntu stonking

💖 MYLOADER(1) — the mydumper girlies' fave little loader 💖

okay bestie, welcome to myloader, lived in the mydumper manual, and I'm about to make you obsessed with restoring backups. 🦋

✨ NAME ✨

myloader — a multi-threaded MySQL loader 🌈 (yes she multitasks, she's that girl)

✨ SYNOPSIS ✨

myloader --directory = /path/to/mydumper/backup [OPTIONS]

✨ DESCRIPTION ✨

So like, myloader is the tool you use for multi-threaded restoration of mydumper backups. That's it, that's the whole vibe. Dump it with mydumper, load it back with myloader, eat 💅

✨ OPTIONS ✨

The myloader tool has several available options, and we're going through ALL of them because I do not skip. periodt 💖

  • --help, -? — shows you the help text. your little cheat sheet, no shame in it 🎀
  • --defaults-file — use the option file you point at. and here's the chill part: if the file doesn't exist or is otherwise inaccessible, no failure occurs. she simply moves on 😌
  • --host, -h — hostname of the MySQL server to connect to (default is localhost)
  • --user, -u — the MySQL username, and she needs the correct privileges to execute the restoration. don't come at her underprivileged, bestie 👑
  • --password, -p — the corresponding password for that MySQL user 🔐
  • --port, -P — the port for the MySQL connection.
NOTE: for localhost TCP connections use 127.0.0.1 for --host. literally not localhost, use 127.0.0.1. iykyk 😭
  • --socket, -S — the UNIX domain socket file to use for the connection
  • --threads, -t — the number of threads to use for restoring data, default is 4. four girlies working in parallel, iconic 🧚
  • --version, -V — show the program version and exit
  • --compress-protocol, -C — use client protocol compression for connections to the MySQL server. squeeze it, slay 🌸
  • --directory, -d — the directory of the mydumper backup to restore
  • --database, -B — an alternative database to load the dump into
NOTE: this is for use with single database dumps. when using with multi-database dumps that have duplicate table names in more than one database it may cause errors. alternatively this scenario may give unpredictable results with --overwrite-tables. so like, be careful, bestie 💀
  • --source-db, -s — database to restore, useful in combination with –database
  • --queries-per-transaction, -q — number of INSERT queries to execute per transaction during restore, default is 1000.
  • --overwrite-tables, -o — drop any existing tables when restoring schemas. she said out with the old 🔥
  • --enable-binlog, -e — log the data loading in the MySQL binary log if enabled (off by default)
  • --verbose, -v — the verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info. default is 2.

✨ AUTHOR ✨

Andrew Hutchings 💜

2011, Andrew Hutchings

and that's the whole page, babe 🫶 this was version 0.10.0, dated Sep 22, 2025 — go forth and restore, you absolute legend ⭐🌈💖

📦 where this page comes from