- 4.6 MySQL Administrative and Utility Programs
- 4.6.1 innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2 myisam_ftdump — Display Full-Text Index information
- 4.6.3 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4 myisamlog — Display MyISAM Log File Contents
- 4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6 mysqlaccess — Client for Checking Access Privileges
- 4.6.7 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.8 mysqldumpslow — Summarize Slow Query Log Files
- 4.6.9 mysqlhotcopy — A Database Backup Program
- 4.6.10 mysqlmanager — The MySQL Instance Manager
- 4.6.11 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12 mysql_find_rows — Extract SQL Statements from Files
- 4.6.13 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.14 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.15 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.16 mysql_zap — Kill Processes That Match a Pattern
mysql_find_rows reads files containing SQL
statements and extracts statements that match a given regular
expression or that contain USE
or
db_nameSET
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:
-
Display a help message and exit.
-
Display queries that match the pattern.
-
Quit after displaying
Nqueries. -
Do not include
USEstatements in the output.db_name -
Start output from this row.
User Comments
Add your own comment.