dbs_empty - Empty SQL Databases
dbs_empty is an utility that completely erases any data from a given SQL database.
Required command line parameters are the DBI driver (Pg for Postgres or mysql for MySQL) and the database name. The third parameter is optionally and specifies the database user and/or the host where the database resides (racke, racke@linuxia.de or @linuxia.de).
Pg
mysql
racke
racke@linuxia.de
@linuxia.de
Excludes any table matching the regular expression REGEXP from dumping.
Remove tables from database too.
Stefan Hornburg (Racke), racke@linuxia.de
perl(1), DBIx::Easy(3)
To install DBIx::Easy, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Easy
CPAN shell
perl -MCPAN -e shell install DBIx::Easy
For more information on module installation, please visit the detailed CPAN module installation guide.