SQL::Tr...::Dumper(3)

SQL::Tr...::Dumper(3) 💅✨

Okay bestie, welcome to the User Contributed Perl Documentation page for SQL::Tr...::Dumper(3) — yes, the manual name is literally SQL::Tr...::Dumper(3), and it's giving database-dumper realness. Let's get into it 🫶

---

🌸 NAME 🌸

SQL::Tr...::Dumper — SQL Dumper producer for SQL::Translator, no cap 💖

---

✨ SYNOPSIS ✨

use SQL::Translator::Producer::Dumper;

Options:

  db_user         Database username
  db_password     Database password
  dsn             DSN for DBI
  mysql_loadfile  Create MySQL's LOAD FILE syntax instead of INSERTs
  skip=t1[,t2]    Skip tables in comma-separated list
  skiplike=regex  Skip tables in comma-separated list

---

💖 DESCRIPTION 💖

So this producer creates a Perl script that can connect to a database and dump the data as INSERT statements (a la mysqldump) or as a file suitable for MySQL's LOAD DATA command. Iconic behavior, honestly 🎀

If you enable add-truncate or specify tables to skip (also using the skiplike regular expression), then the generated dumper script will leave out those tables. Plot twist: these will also be options in the generated dumper, so you can wait to specify these options when you dump your database. Very choose-your-own-adventure of it all ✨

The database username, password, and DSN can be hardcoded into the generated script, or part of the DSN can be intuited from the database argument. Flexible? Obsessed. 💅

---

🎀 AUTHOR 🎀

Ken Youens-Clark <kclark@cpan.org>. Periodt 💖

---

Source/version vibe check: perl v5.42.0, dated 2024-12-12. Byeee bestie, go dump that data responsibly 😭🌸🫶