Mysql怎么讀.frm結尾的表結構定義文件

這篇文章給大家分享的是有關Mysql怎么讀.frm結尾的表結構定義文件的內容。小編覺得挺實用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。

用mysqlfrm工具讀.frm結尾的表結構定義文件
到網站下載rpm包
http://rpm.pbone.net/
上傳到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的信息。

感謝各位的閱讀！關于“Mysql怎么讀.frm結尾的表結構定義文件”這篇文章就分享到這里了，希望以上內容可以對大家有一定的幫助，讓大家可以學到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！