DBS_EMPTY(1p)

💖 NAME 💖

dbs_empty — the little utility that empties SQL databases, like a full factory reset but for your data 🌸

---

✨ DESCRIPTION ✨

okay so bestie, picture this: you have an SQL database and you want it absolutely, completely, no-notes, no-leftovers scrubbed of every scrap of data. That's literally what dbs_empty does. It's a utility that completely erases any data from a given SQL database. Gone. Poof. Not a single row left to tell the tale 💅

---

🎀 COMMAND LINE PARAMETERS 🎀

The required command line parameters are:

1. the DBI driver — and before you ask, it's "Pg" for Postgres or "mysql" for MySQL 🫶
2. the database name

The third parameter is optional and it specifies the database user and/or the host where the database resides. Like so:

• "racke" — just the user
• "racke@linuxia.de" — user and host
• "@linuxia.de" — just the host

---

🦋 COMMAND LINE OPTIONS 🦋

--exclude-matching-tables=REGEXP

Excludes any table matching the regular expression REGEXP from dumping 🙈 so if there's a table you're emotionally attached to and refuse to let go of, this is your girl.

-t, --tables

Remove tables from database too 👑 not just the data — the whole tables, bye. No cap.

---

🌈 AUTHOR 🌈

Stefan Hornburg (Racke), racke@linuxia.de — the icon who made this, we stan 💜

---

⭐ SEE ALSO ⭐

• perl(1)
• DBIx::Easy(3)

---

perl v5.32.0 · 2021-01-06 — that's the version and date this page was living in, bestie, and honestly? iconic. go empty some databases, slay, and remember: back up first, fr fr 💖✨