Oracle 5.0, Справочное руководство

Страница: 386 / 3232

mysql_find_rows
— Extract SQL Statements from Files
366
Specifying a password on the command line should be considered insecure. See Section 6.1.2.1,
“End-User Guidelines for Password Security” .
•
--printerror=1
[366] ,
-e 1
Enable error output.
•
--socket=path
[366] ,
-S path
For connections to
localhost
, the Unix socket file to use, or, on Windows, the name of the named
pipe to use.
•
--user=user_name
[366] ,
-u user_name
The MySQL user name to use when connecting to the server.
4.6.13.
mysql_find_rows
— Extract SQL Statements from Files
mysql_find_rows
reads files containing SQL statements and extracts statements that match a given
regular expression or that contain
USE db_name
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.
Invoke
mysql_find_rows
like this:
shell> mysql_find_rows [options] [file_name ...]
Each
file_name
argument should be the name of file containing SQL statements. If no file names are
given,
mysql_find_rows
reads the standard input.
Examples:
mysql_find_rows --regexp=problem_table --rows=20 < update.log
mysql_find_rows --regexp=problem_table update-log.1 update-log.2
mysql_find_rows
supports the following options:
•
--help
[366] ,
--Information
[366]
Display a help message and exit.
•
--regexp=pattern
[366]
Display queries that match the pattern.
•
--rows=N
[366]
Quit after displaying
N
queries.
•
--skip-use-db
[366]
Do not include
USE db_name
statements in the output.
•
--start_row=N
[366]
Start output from this row.
4.6.14.
mysql_fix_extensions
— Normalize Table File Name Extensions
mysql_fix_extensions
converts the extensions for
MyISAM
(or
ISAM
) table files to their canonical
forms. It looks for files with extensions matching any lettercase variant of
.frm
,
.myd
,
.myi
,
.isd
,
and
.ism
and renames them to have extensions of
.frm
,
.MYD
,
.MYI
,
.ISD
, and
.ISM
, respectively.