当前位置：Gxlcms > 数据库问题 > （转）MySQL管理工具MySQL Utilities — mysqlfrm (26)

（转）MySQL管理工具MySQL Utilities — mysqlfrm (26)

时间：2021-07-01 10:21:17 帮助过：71人阅读

License type: GPLv2 Usage: mysqlfrm --server=[user[:<pass>]@host[:<port>][:<socket>]|<login-path>[:<port>][:<socket>]] [path\tbl1.frm|db:tbl.frm] mysqlfrm - show CREATE TABLE from .frm files Options: --version show program‘s version number and exit --license display program‘s license and exit --help --basedir=BASEDIR the base directory for the server,默认模式 --diagnostic read the frm files byte-by-byte to form the CREATE statement. May require the --server or --basedir options to decipher character set information --new-storage-engine=NEW_ENGINE change ENGINE clause to use this engine. --frmdir=FRMDIR save the new .frm files in this directory. Used and valid with --new-storage-engine only. --port=PORT Port to use for the spawned server.未使用的端口，默认模式 -s, --show-stats show file statistics and general table information. --server=SERVER connection information for the server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>] (optional) - if provided, the storage engine and character set information will be validated against this server. --user=USER user account to launch spawned server. Required if running as root user. Used only in the default mode. --start-timeout=START_TIMEOUT Number of seconds to wait for spawned server to start. Default = 10. -v, --verbose control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug -q, --quiet turn off all messages for quiet execution. --ssl-ca=SSL_CA The path to a file that contains a list of trusted SSL CAs. --ssl-cert=SSL_CERT The name of the SSL certificate file to use for establishing a secure connection. --ssl-key=SSL_KEY The name of the SSL key file to use for establishing a secure connection.

注意

1. 某些引擎表在默认模式下不可读取的。如PARTITION, PERFORMANCE_SCHEMA，必需在诊断模式下可读。

2. 要在创建语句中改变存储引擎，可使用--new-storage-engine 选项。如果有指定该选项，同时必须指定--frmdir选项，该工具生成新的.frm文件，前缀为new_，并保存在--frmdir目录下。

3. 关掉所有信息除了CREATE 语句和警告或错误信息，使用--quiet选项。

4. 使用--show-stats 选项统计每个.frm文件信息。

5. 使用--user 选项指定再生的实例以哪个权限运行。

6. 如果再生的实例超过10秒启动，需调大--start-timeout 选项参数。

实例

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181

# mysqlfrm --basedir=/usr ttlsa_com:data.frm --port=3333 --user=mysql -vvv # Checking read access to .frm files # Creating a temporary datadir = /data/mydata3306/ttlsa_com/5831a350-3c22-4869-a6d7-9c843fe51ac7 # Spawning server with --user=mysql. # Starting the spawned server on port 3333 ... # Cloning the MySQL server located at /usr. # Configuring new instance... # Locating mysql tools... # Location of files: # mysqld: /usr/sbin/mysqld # mysqladmin: /usr/bin/mysqladmin # mysql_system_tables.sql: /usr/share/mysql/mysql_system_tables.sql # mysql_system_tables_data.sql: /usr/share/mysql/mysql_system_tables_data.sql # mysql_test_data_timezone.sql: /usr/share/mysql/mysql_test_data_timezone.sql # fill_help_tables.sql: /usr/share/mysql/fill_help_tables.sql # Setting up empty database and mysql tables... 2015-01-20 19:12:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-01-20 19:12:35 18168 [Note] Plugin ‘FEDERATED‘ is disabled. 2015-01-20 19:12:35 18168 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-01-20 19:12:35 18168 [Note] InnoDB: The InnoDB memory heap is disabled 2015-01-20 19:12:35 18168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-01-20 19:12:35 18168 [Note] InnoDB: Memory barrier is not used 2015-01-20 19:12:35 18168 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-01-20 19:12:35 18168 [Note] InnoDB: Using Linux native AIO 2015-01-20 19:12:35 18168 [Note] InnoDB: Using CPU crc32 instructions 2015-01-20 19:12:35 18168 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-01-20 19:12:35 18168 [Note] InnoDB: Completed initialization of buffer pool 2015-01-20 19:12:35 18168 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2015-01-20 19:12:35 18168 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2015-01-20 19:12:35 18168 [Note] InnoDB: Database physically writes the file full: wait... 2015-01-20 19:12:35 18168 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2015-01-20 19:12:36 18168 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2015-01-20 19:12:36 18168 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2015-01-20 19:12:36 18168 [Warning] InnoDB: New log files created, LSN=45781 2015-01-20 19:12:36 18168 [Note] InnoDB: Doublewrite buffer not found: creating new 2015-01-20 19:12:36 18168 [Note] InnoDB: Doublewrite buffer created 2015-01-20 19:12:36 18168 [Note] InnoDB: 128 rollback segment(s) are active. 2015-01-20 19:12:36 18168 [Warning] InnoDB: Creating foreign key constraint system tables. 2015-01-20 19:12:36 18168 [Note] InnoDB: Foreign key constraint system tables created 2015-01-20 19:12:36 18168 [Note] InnoDB: Creating tablespace and datafile system tables. 2015-01-20 19:12:36 18168 [Note] InnoDB: Tablespace and datafile system tables created. 2015-01-20 19:12:36 18168 [Note] InnoDB: Waiting for purge to start 2015-01-20 19:12:36 18168 [Note] InnoDB: 5.6.22 started; log sequence number 0 2015-01-20 19:12:38 18168 [Note] Binlog end 2015-01-20 19:12:38 18168 [Note] InnoDB: FTS optimize thread exiting. 2015-01-20 19:12:38 18168 [Note] InnoDB: Starting shutdown... 2015-01-20 19:12:39 18168 [Note] InnoDB: Shutdown completed; log sequence number 1625977 # Starting new instance of the server... # Startup command for new server: /usr/sbin/mysqld --no-defaults --datadir=/data/mydata3306/ttlsa_com/5831a350-3c22-4869-a6d7-9c843fe51ac7 --tmpdir=/data/mydata3306/ttlsa_com/5831a350-3c22-4869-a6d7-9c843fe51ac7 --pid-file=/data/mydata3306/ttlsa_com/5831a350-3c22-4869-a6d7-9c843fe51ac7/clone.pid --port=3333 --server-id=101 --basedir=/usr --socket=/data/mydata3306/ttlsa_com/5831a350-3c22-4869-a6d7-9c843fe51ac7/mysql.sock --user=mysql # Testing connection to new instance... 2015-01-20 19:12:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-01-20 19:12:40 18193 [Note] Plugin ‘FEDERATED‘ is disabled. 2015-01-20 19:12:40 18193 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-01-20 19:12:40 18193 [Note] InnoDB: The InnoDB memory heap is disabled 2015-01-20 19:12:40 18193 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-01-20 19:12:40 18193 [Note] InnoDB: Memory barrier is not used

（转）MySQL管理工具MySQL Utilities — mysqlfrm (26)

注意

实例

人气教程排行