1MYSQL_CONVERT_TAB(1)        MariaDB Database System       MYSQL_CONVERT_TAB(1)
2
3
4

NAME

6       mysql_convert_table_format - convert tables to use a given storage
7       engine
8

SYNOPSIS

10       mysql_convert_table_format [options] db_name
11

DESCRIPTION

13       mysql_convert_table_format converts the tables in a database to use a
14       particular storage engine (MyISAM by default).
15       mysql_convert_table_format is written in Perl and requires that the DBI
16       and DBD::mysql Perl modules be installed (see Section 2.15, “Perl
17       Installation Notes”).
18
19       Invoke mysql_convert_table_format like this:
20
21           shell> mysql_convert_table_format [options]db_name
22
23       The db_name argument indicates the database containing the tables to be
24       converted.
25
26       mysql_convert_table_format supports the options described in the
27       following list.
28
29       ·   --help
30
31           Display a help message and exit.
32
33       ·   --force
34
35           Continue even if errors occur.
36
37       ·   --host=host_name
38
39           Connect to the MariaDB server on the given host.
40
41       ·   --password=password
42
43           The password to use when connecting to the server. Note that the
44           password value is not optional for this option, unlike for other
45           MariaDB programs.
46
47           Specifying a password on the command line should be considered
48           insecure. You can use an option file to avoid giving the password
49           on the command line.
50
51       ·   --port=port_num
52
53           The TCP/IP port number to use for the connection.
54
55       ·   --socket=path
56
57           For connections to localhost, the Unix socket file to use.
58
59       ·   --type=engine_name
60
61           Specify the storage engine that the tables should be converted to
62           use. The default is MyISAM if this option is not given.
63
64       ·   --user=user_name
65
66           The MariaDB user name to use when connecting to the server.
67
68       ·   --verbose
69
70           Verbose mode. Print more information about what the program does.
71
72       ·   --version
73
74           Display version information and exit.
75
77       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.,
78       2010-2015 MariaDB Foundation
79
80       This documentation is free software; you can redistribute it and/or
81       modify it only under the terms of the GNU General Public License as
82       published by the Free Software Foundation; version 2 of the License.
83
84       This documentation is distributed in the hope that it will be useful,
85       but WITHOUT ANY WARRANTY; without even the implied warranty of
86       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
87       General Public License for more details.
88
89       You should have received a copy of the GNU General Public License along
90       with the program; if not, write to the Free Software Foundation, Inc.,
91       51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see
92       http://www.gnu.org/licenses/.
93
94

SEE ALSO

96       For more information, please refer to the MariaDB Knowledge Base,
97       available online at https://mariadb.com/kb/
98

AUTHOR

100       MariaDB Foundation (http://www.mariadb.org/).
101
102
103
104MariaDB 10.3                      9 May 2017              MYSQL_CONVERT_TAB(1)
Impressum