.\" -*- mode: troff; coding: utf-8 -*- .\" Automatically generated by Pod::Man 5.01 (Pod::Simple 3.43) .\" .\" Standard preamble: .\" ======================================================================== .de Sp \" Vertical space (when we can't use .PP) .if t .sp .5v .if n .sp .. .de Vb \" Begin verbatim text .ft CW .nf .ne \\$1 .. .de Ve \" End verbatim text .ft R .fi .. .\" \*(C` and \*(C' are quotes in nroff, nothing in troff, for use with C<>. .ie n \{\ . ds C` "" . ds C' "" 'br\} .el\{\ . ds C` . ds C' 'br\} .\" .\" Escape single quotes in literal strings from groff's Unicode transform. .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" .\" If the F register is >0, we'll generate index entries on stderr for .\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index .\" entries marked with X<> in POD. Of course, you'll have to process the .\" output yourself in some meaningful fashion. .\" .\" Avoid warning from groff about undefined register 'F'. .de IX .. .nr rF 0 .if \n(.g .if rF .nr rF 1 .if (\n(rF:(\n(.g==0)) \{\ . if \nF \{\ . de IX . tm Index:\\$1\t\\n%\t"\\$2" .. . if !\nF==2 \{\ . nr % 0 . nr F 2 . \} . \} .\} .rr rF .\" ======================================================================== .\" .IX Title "DBS_EMPTY 1p" .TH DBS_EMPTY 1p 2024-03-24 "perl v5.38.2" "User Contributed Perl Documentation" .\" For nroff, turn off justification. Always turn off hyphenation; it makes .\" way too many mistakes in technical documents. .if n .ad l .nh .SH NAME dbs_empty \- Empty SQL Databases .SH DESCRIPTION .IX Header "DESCRIPTION" dbs_empty is an utility that \fBcompletely erases\fR any data from a given SQL database. .SH "COMMAND LINE PARAMETERS" .IX Header "COMMAND LINE PARAMETERS" Required command line parameters are the DBI driver (\f(CW\*(C`Pg\*(C'\fR for Postgres or \f(CW\*(C`mysql\*(C'\fR for MySQL) and the database name. The third parameter is optionally and specifies the database user and/or the host where the database resides (\f(CW\*(C`racke\*(C'\fR, \f(CW\*(C`racke@linuxia.de\*(C'\fR or \f(CW\*(C`@linuxia.de\*(C'\fR). .SH "COMMAND LINE OPTIONS" .IX Header "COMMAND LINE OPTIONS" .SS \fB\-\-exclude\-matching\-tables\fP=REGEXP .IX Subsection "--exclude-matching-tables=REGEXP" Excludes any table matching the regular expression REGEXP from dumping. .SS "\fB\-t, \-\-tables\fP" .IX Subsection "-t, --tables" Remove tables from database too. .SH AUTHOR .IX Header "AUTHOR" Stefan Hornburg (Racke), racke@linuxia.de .SH "SEE ALSO" .IX Header "SEE ALSO" \&\fBperl\fR\|(1), \fBDBIx::Easy\fR\|(3)