Shulou(Shulou.com)05/31 Report--

This article is about how Mysql reads the table structure definition file at the end of .frm. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Read the table structure definition file at the end of .frm with mysqlfrm tool

Download the rpm package from the website

Http://rpm.pbone.net/

Upload to the mysql server

[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

Found that there is a dependency.

Download mysql-connector-python again

[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%]

Installation succeeded.

[root@test ~] # mysqlfrm / data/mysql/pou_prepub/temp_point_up.frm

Usage: mysqlfrm-- server= [user [:] @ host [:] [:] | [:] [:]] [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 (41dy0) DEFAULT NULL

`member_ id` bigint (20) NOT NULL comment 'member ID'

) ENGINE=InnoDB

#... done.

Read out the information of .frm.

Thank you for reading! This is the end of the article on "how to read the table structure definition file at the end of .frm by Mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.