ARIA_PACK(1)

πŸ“¦
version 13.0.2 Β· 2 versions
, in alpine 3.22, alpine 3.23, alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian bookworm, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu resolute, ubuntu stonking

πŸ’– ARIA_PACK(1) β€” the user-commands girlies πŸ’–

okay so bestie, welcome to aria_pack from the User Commands corner of the manual. it's giving "tiny tool, big compression energy" and i'm obsessed πŸ’…


✨ NAME ✨

aria_pack β€” generate compressed, read-only Aria tables πŸŽ€


🌸 SYNOPSIS 🌸

aria_pack [OPTIONS] filename...

πŸ¦‹ DESCRIPTION πŸ¦‹

so the whole vibe here is: you pack an Aria table so it takes up way less space. slay. but listen β€” keys are not updated. so after you're done, you must run aria_chk -rq on the index (.MAI) file to update the keys. no cap, don't skip that step or you'll be sad 😭

and the filename argument you hand over? that should be the .MAI file. that's the one. 🫢

and to unpack a packed table, you run aria_chk -u on the table. that's the un-pack. the reverse. the uno-reverse card, if you will πŸƒ


πŸŽ€ OPTIONS πŸŽ€ (yes every single one, we don't gatekeep)

  • -b, --backup β€” makes a backup of the table named table_name.OLD. safety first, bestie πŸ›Ÿ
  • --character-sets-dir=name β€” the directory where the character sets live. that's their house 🏠
  • -#, --debug[=name] β€” spits out a debug log. a lot of the time it looks like 'd:t:o,filename'. very "here's my diary, read it" πŸ’€
  • -f, --force β€” forces the packing even if the table ends up bigger 😭 or if the tempfile already exists. chaotic but valid.
  • -j, --join=name β€” joins all the tables you gave it into 'new_table_name'. ⚠️ all tables MUST have identical layouts, no exceptions, they have to match fr fr.
  • -?, --help β€” shows this help and dips out. classic πŸ‘‹
  • -s, --silent β€” be more silent. shhh 🀫
  • -T, --tmpdir=name β€” use this temporary directory to store the temporary table. temp table's temp home ✨
  • -t, --test β€” doesn't actually pack the table, just tests packing it. a dress rehearsal, iconic 🎭
  • -v, --verbose β€” writes info about progress and the packing result. and bestie β€” use many -v for more verbosity! stack 'em, the more the louder πŸ“’
  • -V, --version β€” outputs version info and exits. the "who am i" moment πŸ’
  • -w, --wait β€” waits and retries if the table is in use. patient queen energy πŸ‘‘

🌈 DEFAULT OPTIONS, WHERE THEY COME FROM 🌈

default options get read from these files, in this exact order:

  1. /etc/my.cnf
  2. /etc/mysql/my.cnf
  3. ~/.my.cnf

and the following groups get read: ariapack πŸ“š


πŸ‘‘ the "give me these as the first argument" club πŸ‘‘

the following options may be given as the first argument:

  • --print-defaults β€” print the program argument list and exit. show us the receipts 🧾
  • --no-defaults β€” don't read default options from any option file. none. zero. we're going rogue 🚫
  • --defaults-file=# β€” only read default options from the given file #. one file, one love πŸ’œ
  • --defaults-extra-file=# β€” read this file after the global files are read. late to the party but still invited πŸŽ‰

πŸ’« SEE ALSO πŸ’«

  • myisampack(1) β€” the sibling, the cousin, the other one 🫢

for more info, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/ πŸ“–βœ¨


and that's the whole page, bestie!! this was aria_pack Ver 1.0, dated May 2014 β€” yeah she's a 2014 girlie and she still eats πŸ’…πŸ§šπŸ’–

πŸ“¦ where this page comes from