Mysql如何讀.frm結尾的表結構定義檔案

用mysqlfrm工具讀.frm結尾的表結構定義檔案
到網站下載rpm包

上傳到mysql伺服器上
[root@test ~]# rpm -ivh mysql-utilities-1.6.5-1.el6.noarch.rpm 
warning: mysql-utilities-1.6.5-1.el6.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        mysql-connector-python >= 2.0.0 is needed by mysql-utilities-1.6.5-1.el6.noarch

發現有依賴關係。
再下載mysql-connector-python
[root@test ~]# rpm -ivh mysql-connector-python-2.1.7-1.el6.x86_64.rpm 
warning: mysql-connector-python-2.1.7-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-connector-python ########################################### [100%]
[root@test ~]# rpm -ivh mysql-utilities-1.6.5-1.el6.noarch.rpm 
warning: mysql-utilities-1.6.5-1.el6.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-utilities        ########################################### [100%]
安裝成功。

[root@test ~]# mysqlfrm /data/mysql/pou_prepub/temp_point_up.frm
Usage: mysqlfrm --server=[user[:<pass>]@host[:<port>][:<socket>]|<login-path>[:<port>][:<socket>]] [path\tbl1.frm|db:tbl.frm]


mysqlfrm: error: The --port option is required for reading .frm files in the default mode.
[root@test ~]# mysqlfrm --diagnostic /data/mysql/pou_prepub/temp_point_up.frm
# WARNING: Cannot generate character set or collation names without the --server option.
# CAUTION: The diagnostic mode is a best-effort parse of the .frm file. As such, it may not identify all of the components of the table correctly. This is especially true for damaged files. It will also not read the default values for the columns and the resulting statement may not be syntactically correct.
# Reading .frm file for /data/mysql/pou_prepub/temp_point_up.frm:
# The .frm file is a TABLE.
# CREATE TABLE Statement:


CREATE TABLE `pou_prepub`.`temp_point_up` (
  `sum(point)` decimal(41,0) DEFAULT NULL, 
  `member_id` bigint(20) NOT NULL comment '會員ID' 
) ENGINE=InnoDB;


#...done.

讀出了.frm的資訊。