mysqlfrm utility in MySQL

MySQL utility - mysqlfrm cheatsheet

mysqlfrm          show CREATE TABLE from .frm files and .frm/.idb files reader utility

MySQL utility mysqlfrm is designed as a recovery tool that reads .frm files and generates CREATE statements from the table definition data in the file, useful to recreate the tables on another server.

Usage: mysqlfrm --server=[user[:pass]@host[:port][:socket]|login-path[:port][:socket]] [path\tbl1.frm|db:tbl.frm]

mysqlfrm --help
mysqlfrm --version

mysqlfrm --basedir=/usr/local/bin/mysql testdb:city.frm --port=3333 --quiet
mysqlfrm --server=root:@localhost:3310 invoices.frm --port=3333
mysqlfrm --server=dba invoices.frm --port=3333 --verbose
mysqlfrm --server=root:pass@localhost:3309 /mysql/data/temp1/t1.frm /mysql/data/temp2/g1.frm --port=3310
mysqlfrm --server=root:pass@localhost:3309 /mysql/data/temp1/t1.frm /mysql/data/temp2/db1:t2.frm --port=3310

mysqlfrm --server=mysql_dba /mysql/data/temp1/t1.frm /mysql/data/temp2/g1.frm --port=3310 --user=user
mysqlfrm --diagnostic /mysql/data/testdatabase
mysqlfrm --diagnostic /usr/local/mysql/data/new_table.frm
mysqlfrm --diagnostic /mysql/data/employee.frm > /mysql/data/recovered_emp.sql

mysqlfrm --server=root:password@localhost:3308 F:\mysql\utilities\mysqlfrm\File.frm > file.txt --diagnostic
mysqlfrm --server=root:pass@localhost --port=3310 --user=mysql /usr/local/mysql/data/employees
mysqlfrm --server=root:pass@localhost --diagnostic --show-stats --new-storage-engine=MEMORY /usr/local/mysql/data/employees/titles.frm

mysqlfrm 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: [: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 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         path to a file that contains a list of trusted SSL    CAs.
  --ssl-cert=SSL_CERT   name of the SSL certificate file to use for   establishing a secure connection.
  --ssl-key=SSL_KEY     name of the SSL key file to use for establishing a  secure connection.
  --ssl=SSL                   specifies if the server connection requires use of SSL. 
If an encrypted connection cannot be established, the connection attempt fails. By default 0 (SSL not required).


Related MySQL Articles: MySQL utility mysqlprocgrep cheatsheet