Name
mysql_convert_table_format
Synopsis
mysql_convert_table_formatoptions
database
This utility converts all tables in a given database from one
storage engine to another. By default it converts them to MyISAM. The
program requires that Perl and the Perl DBI module and
DBD::mysql
be installed on the system where it’s
executed.
mysql_convert_table_format options
--force
This option instructs the utility to keep running despite errors.
--host=
,host
-h
host
This option specifies the host on which to connect and to convert tables.
--help
,-?
This option displays help information about the utility.
--password=
,password
-p
password
This option provides the password of the user logging into the server.
--port=
port
This option specifies the port on which to connect to the server. The default is 3306.
--socket=
,filename
-S
filename
This option provides the name of the server’s socket file.
--type=
engine
This option specifies the storage engine to which to convert tables. If not given, MyISAM is assumed.
--user=
,user
-u
user
This option provides the username for logging into the server.
--verbose
This option displays more information from the utility.
--version
This option returns the version of the utility.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.