Imported freely distributable documentation from upstream MySQL 5.1.34 source tarball.

1 files changed, 98 insertions, 0 deletions

diff --git a/man/mysql_find_rows.1 b/man/mysql_find_rows.1
new file mode 100644
index 00000000000..cd265b96934
--- /dev/null
+++ b/man/mysql_find_rows.1
@@ -0,0 +1,98 @@
+.\"     Title: \fBmysql_find_rows\fR
+.\"    Author: 
+.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/>
+.\"      Date: 03/31/2009
+.\"    Manual: MySQL Database System
+.\"    Source: MySQL 5.1
+.\"
+.TH "\fBMYSQL_FIND_ROWS\\F" "1" "03/31/2009" "MySQL 5.1" "MySQL Database System"
+.\" disable hyphenation
+.nh
+.\" disable justification (adjust text to left margin only)
+.ad l
+.SH "NAME"
+mysql_find_rows \- extract SQL statements from files
+.SH "SYNOPSIS"
+.HP 42
+\fBmysql_find_rows [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIfile_name\fR\fR\fB ...]\fR
+.SH "DESCRIPTION"
+.PP
+\fBmysql_find_rows\fR
+reads files containing SQL statements and extracts statements that match a given regular expression or that contain
+USE \fIdb_name\fR
+or
+SET
+statements. The utility was written for use with update log files (as used prior to MySQL 5.0) and as such expects statements to be terminated with semicolon (;) characters. It may be useful with other files that contain SQL statements as long as statements are terminated with semicolons.
+.PP
+Invoke
+\fBmysql_find_rows\fR
+like this:
+.sp
+.RS 3n
+.nf
+shell> \fBmysql_find_rows [\fR\fB\fIoptions\fR\fR\fB] [\fR\fB\fIfile_name\fR\fR\fB ...]\fR
+.fi
+.RE
+.PP
+Each
+\fIfile_name\fR
+argument should be the name of file containing SQL statements. If no file names are given,
+\fBmysql_find_rows\fR
+reads the standard input.
+.PP
+Examples:
+.sp
+.RS 3n
+.nf
+mysql_find_rows \-\-regexp=problem_table \-\-rows=20 < update.log
+mysql_find_rows \-\-regexp=problem_table  update\-log.1 update\-log.2
+.fi
+.RE
+.PP
+\fBmysql_find_rows\fR
+supports the following options:
+.TP 3n
+\(bu
+\fB\-\-help\fR,
+\fB\-\-Information\fR
+.sp
+Display a help message and exit.
+.TP 3n
+\(bu
+\fB\-\-regexp=\fR\fB\fIpattern\fR\fR
+.sp
+Display queries that match the pattern.
+.TP 3n
+\(bu
+\fB\-\-rows=\fR\fB\fIN\fR\fR
+.sp
+Quit after displaying
+\fIN\fR
+queries.
+.TP 3n
+\(bu
+\fB\-\-skip\-use\-db\fR
+.sp
+Do not include
+USE \fIdb_name\fR
+statements in the output.
+.TP 3n
+\(bu
+\fB\-\-start_row=\fR\fB\fIN\fR\fR
+.sp
+Start output from this row.
+.SH "COPYRIGHT"
+.PP
+Copyright 2007\-2008 MySQL AB, 2009 Sun Microsystems, Inc.
+.PP
+This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
+.PP
+This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
+.PP
+You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110\-1301 USA or see http://www.gnu.org/licenses/.
+.SH "SEE ALSO"
+For more information, please refer to the MySQL Reference Manual,
+which may already be installed locally and which is also available
+online at http://dev.mysql.com/doc/.
+.SH AUTHOR
+MySQL AB (http://www.mysql.com/).