- 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_explain_log — Use EXPLAIN on Statements in Query Log
- 4.6.13 mysql_find_rows — Extract SQL Statements from Files
- 4.6.14 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.15 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.16 mysql_tableinfo — Generate Database Metadata
- 4.6.17 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.18 mysql_zap — Kill Processes That Match a Pattern
mysql_tableinfo creates tables and populates
them with database metadata. It uses SHOW
DATABASES, SHOW TABLES,
SHOW TABLE STATUS,
SHOW COLUMNS, and
SHOW INDEX to obtain the
metadata.
In MySQL 5.0 and up, the INFORMATION_SCHEMA
database contains the same kind of information in the
SCHEMATA,
TABLES,
COLUMNS, and
STATISTICS tables. See
Chapter 19, INFORMATION_SCHEMA Tables.
Invoke mysql_tableinfo like this:
shell> mysql_tableinfo [options] db_name [db_like [tbl_like]]
The db_name argument indicates which
database mysql_tableinfo should use as the
location for the metadata tables. The database will be created
if it does not exist. The tables will be named
db, tbl (or
tbl_status), col, and
idx.
If the db_like or
tbl_like arguments are given, they
are used as patterns and metadata is generated only for
databases or tables that match the patterns. These arguments
default to % if not given.
Examples:
mysql_tableinfo info mysql_tableinfo info world mysql_tableinfo info mydb tmp%
Each of the commands stores information into tables in the
info database. The first stores information
for all databases and tables. The second stores information for
all tables in the world database. The third
stores information for tables in the mydb
database that have names matching the pattern
tmp%.
mysql_tableinfo supports the following options:
Table 4.13. mysql_tableinfo
Options
| Format | Config File | Description | Introduction | Deprecated | Removed |
|---|---|---|---|---|---|
| --clear | clear | Before populating each metadata table, drop it if it exists | |||
| --clear-only | clear-only | Similar to --clear, but exits after dropping the metadata tables to be populated. | |||
| --col | col | Generate column metadata into the col table | |||
| --help | Display help message and exit | ||||
| --host=host_name | host | Connect to the MySQL server on the given host | |||
| --idx | idx | Generate index metadata into the idx table | |||
| --password=password | password | The password to use when connecting to the server -- not optional | |||
| --port=port_num | port | The TCP/IP port number to use for the connection | |||
| --prefix=prefix_str | prefix | Add prefix_str at the beginning of each metadata table name | |||
| --quiet | quiet | Be silent except for errors | |||
| --socket=path | socket | Display version information and exit | |||
| --tbl-status | tbl-status | Use SHOW TABLE STATUS instead of SHOW TABLES | |||
| --user=user_name, | user | The mysql_tableinfo user name to use when connecting to the server |
-
Display a help message and exit.
-
Before populating each metadata table, drop it if it exists.
-
Similar to
--clear, but exits after dropping the metadata tables to be populated. -
Generate column metadata into the
coltable. -
--host=,host_name-hhost_nameConnect to the MySQL server on the given host.
-
Generate index metadata into the
idxtable. -
--password=,password-ppasswordThe password to use when connecting to the server. Note that the password value is not optional for this option, unlike for other MySQL programs. You can use an option file to avoid giving the password on the command line.
Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, “End-User Guidelines for Password Security”.
-
--port=,port_num-Pport_numThe TCP/IP port number to use for the connection.
-
Add
prefix_strat the beginning of each metadata table name. -
--quiet,-qBe silent except for errors.
-
--socket=,path-SpathThe Unix socket file to use for the connection.
-
Use
SHOW TABLE STATUSinstead ofSHOW TABLES. This provides more complete information, but is slower. -
--user=,user_name-uuser_nameThe MySQL user name to use when connecting to the server.
User Comments
Add your own comment.