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